1410

Delphi List Odbc Drivers

Download dbForge SQL Complete Devart provides either evaluation or free downloads for all of its software products. You can. No more missed important software updates UpdateStar 11 lets you stay up to date and secure with the software on your computer. List of Linux Databases and Database Related Links. Free Open Source as well as industrial strength Oracle, DB2, Informix and Sybase commercially supported databases. Delphi on 6. 4 bit Windows 7. Some 6. 4 bit Windows notes File location 3. Program Files x. Program Files. Likewise, 3. WindowsSys. WOW6. WindowsSystem. Microsoft contrarian logic for you Registry keys also are affected so that 3. HKLMSOFTWARE key are now installed by Win 7 into HKLMSOFTWAREWOW6. Node and legacy programs may not know to look for them there eg. Delphi FAQ Abstract QAwww. Wedelphi. com201310delphi. The following tables compare general and technical information for a number of available database administrator tools. Please see individual product articles for. FILExt. com is the file extension source. Here youll find a collection of file extensions many linked to the programs that created the files. This is the FILExt home. IDE-ODBC-PostgreSQL.png' alt='Delphi List Odbc Drivers' title='Delphi List Odbc Drivers' />BDEAdmin. ODBC drivers are set up using 3. ODBC control panel interface found here WINDIRSys. WOW6. 4odbcad. 32. ODBC drivers are set up using the default 6. ODBC control panel interface found on Control Panel or here WINDIRSystem. Delphi are 3. 2 bit, that is, although they can run in 6. Win 7, the executables they compile will be 3. Delphi will compile 6. ODBC drivers, dont look in the Control Panel they are the 6. WindowsSys. WOW6. Help system Microsoft ceased installing their legacy Win. Help. 32. exe application in Windows Vista and later. Thus to allow legacy winhelp to function eg. BDE help, you will to download and install it see here. Miami Dade Artificial Reef Program Gulf. Get. Version Get. Version in Vista gave a value of 6 unless you choose to run your app in a compatbility mode in which it will return whichever OS version you choose MS Virtual PC XP Mode a neat little functionality in 6. Win 7 Pro version is the easy ability to create a Win XP virtual machine to run otherwise incompatible legacy software such as old sybase ASE open client drivers, and MS SQL Server 2. XP mode runs as a separate machine and is updated as usual by Windows Update, and will need its own antiviral software. RAM allocation is only 5. Mb. your Delphi 3. I note that I am getting list index out of bounds with one of my apps running in this mode which does not occur on a XP machine nor on 6. Win 7 itself as I do not have Delphi installed in my XP mode virtual machine, I have not debugged why this should occur. With the free VMware Player you can convert this Virtual PC VM and use it with the VMware Player which provides better performance than the XP Mode BUT you will need to pay for Windows OS ie. Windows license keys for each VMWare virtual machine. Delphi in a VM, it gives you several benefits. Very easy to backup your development system and you can easily transfer it to another machine. Plus you can avoid component version conflicts between your products or product versions if you use separate VMs. I am yet to do this, does this affect your Delphi and third party component licenses Jon Aasendens blog post on using VM with various versions of Delphi. UAC, Windows Resource Protection and file virtualization issues introduced in 3. Vista and later Windows OS including 6. Win 7 Changes to HKLM and HKCR registry keys arent allowed under these OS versions without admin rights. Make sure you start any installation with administrator level rights. When installing applications designed prior to Vista, and thus not UAC aware eg. Delphi earlier than Delphi 2. BDE, ensure you avoid the default c Program Files locationsor any other folder path created by the Windows installationThus I install Delphi 6 on c Delphi. Delphi 2. 00. 7 on c Delphi. If you run your 3. Delphi app on a 6. File. Existsfilename may give a false value for files in certain folders eg. WOW6. 4 File Virtualization makes you look at a different folder than the one you think you are looking at. One may need to look at temporarily disabling then re enabling redirection see here. Windows 7 date format bug a known issue with Windows 7 is a bug in date format setting, thus if you use Australian date format, the date format in non main threads remains as USto fix this, in Control Panel, Regional settings, set date format to a non US country date format, press Apply, then reset it to your country and press apply. Australian locale. HKEYCURRENTUSERControl PanelInternationalLocale0. C0. 9Locale. Nameen AUBorland Database Engine BDE Whilst the BDE is no longer supported with updates ceasing some 8 years ago, it is still useful and works well for Paradox, d. Base tables as well as with server databases if used with TClientdatasets. As nice as DBExpress 4 is, it does not support Paradox, d. Base, nor does it seem to support nested SQL statements. The BDE installed fine using default Delphi 6 installation CD with the BDE default installation will be installed in c Program Files x. Common FilesBorland SharedBDE. Alternatively, Do a google search for BDEInfosetup. This will install the BDE on 6. Windows, but it does not put the BDEadmin into the control panel. Instead, go to the directory where the BDE is installed program files x. BorlandCommon FilesBDE and youll find BDEadmin. If you try running BDE Administrator or SQL Explorer and modify an alias and apply edits, the edits will be saved but the app hangs just as it did for these guys in 6. Vista no matter what they triedYou will need to set security for idapi. Modify instead of the default Read only file access, BETTER STILL, move this file away from the c Program Files folder so that users have readwrite access. Ensure BDE Administrator is set to use this new file location by choosing Open Config file, select it then when prompted, Yes to use as default file. You may also need to go into Options from the BDE Administrators Object Menu and check the Win. Ensure pdoxusrs. net file is on a folder with readwrite access for everyone ie. NOT in c folder Now, Delphi may still use the default idapi. HKLMSOFTWAREWOW6. NodeBorlandDatabase EngineCONFIGFILE0. Setting security for idapi. If you install a later version of Delphi after installing an earlier version, remember it will over write your idapi. Now, despite all of the above, the Delphi IDE still seems to want to put the BDE Private. Dir as the c WindowsSystem. Delphi cannot write to in Vista and later. This seems to only be an issue when trying to open TQuery components within the IDE with the cached. Updates true. You will get an error message such as Do not have permission to write c windowssystem. Del. 2. MB, etc. Set TQuery. Cached. Updates false and you are in business. Surely there must be a way to set Delphis Private. Face On Body Pro 2 4. Dir folder to a readwrite folder One unresolved issue is the BDE date format BDE applications seem to default to mdy despite the idapi. HKLMSOFTWAREWOW6. NodeBorlandDatabase EngineSystemFORMATSDATEMODE being set to 1 which should be dmy, even though date settings in Control Panel are set to dmyyyy. A workaround for the date format issue is to call a procedure which sets date format when the application starts I created a procedure based upon the Set. Format. Button. Click code posted here. Installing BDE manually by just installing BDE registry. Win XP BDE registry settings and then just install these on a new machine to allow it to use a file server based BDE configuration. Unfortunately, neither 3. Win 7 will allow a simple install of this. UAC turned off. MS SQL server developer edition Delphi 2. MS SQL Server 2. 00. Win 7, BUT you can install it on XP Mode Virtual PC on Win 7 if you really had to. Old versions of Sybase ASE client also will not install in 6. Win 7 but will install in XP Mode Virtual PCYou can download 3. MS SQL Server 2. 00. Microsoft and install it, and then just copy your old data files from MS SQL Server 2. MS SQL Server 2. 00. Attach these data files to run them. Download and manually install NTWDBLIB. WindowsSys. WOW6.