One my clients has a system written in Delphi 3 and the database is Paradox. My job is to convert it to use SQL Server 2008. How can I make it connect to SQL 2008? This is pretty old stuff, I know. I appreciate the help. Thanks
+5
A:
At the very least BDE should be able connect using ODBC and choosing the SQL 2008 Driver in ODBC. I haven't tried, but I doubt that the BDE SQL driver will connect to SQL 2008, and I doubt anybody will develop a BDE driver for 2k8.
Remus Rusanu
2009-08-04 07:05:28
ODBC is really your only choice here without a lot of re-work.
Tim Jarvis
2009-08-04 07:10:00
The BDE native driver (at least, the last released version of it) will support SQL 2008 if you set the compatibility mode for your database to 80 (SQL 2000) and you have a copy of ntwdblib.dll (last officially released as of SQL 2000).
Scott W
2009-08-04 12:55:03
+1
A:
Do you intend on moving from Delphi 3? If so, then SDAC (SQL Server Direct Access Components) from Devart would be worth looking at. They support SQL Server 2008 but unfortunately require Delphi 5 or above. They use OLE DB and any Windows machine with 2000 or above will have the drivers installed (which is part of Microsoft Data Access Components - MDAC).
Pauk
2009-08-04 10:27:39
+1
A:
You can use ADO without using Ado Components, by importing ActiveX Data Objects Library, but this will require more work.
Mohammed Nasman
2009-08-04 14:23:27
A:
Why not upgrade the project to Delphi 2007 as a stepping stone towards the future? There have been many improvements and bug fixes to the language since Delphi 3 that you could easily take care of. The pain of migration might be much easier than dealing with issues which have been already addressed and corrected in the latest versions of the compiler.
skamradt
2009-08-04 16:22:52
A:
You can try one of the Free Components from Torry.net to connect to the SQL server using ADO.
Check TaoADODataSet and Free ADO Dataset in the page http://www.torry.net/pages.php?id=569. These components have Delphi 3 support.
TwinForms
2009-08-05 18:20:31