1

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

Johan
  • 74,508
  • 24
  • 191
  • 319
Gus Cavalcanti
  • 10,527
  • 23
  • 71
  • 104
  • If you are making such a fundamental change, then be sure to upgrade your Delphi version too. The cost in effort will be the same, but you'll gain the advantages of all the later versions of Delphi too. – mj2008 Aug 04 '09 at 11:06
  • It should be trivially easy to port to Delphi 2007. Beyond 2007 you have to do the "unicode" porting changes. Moving up to 2007 makes sense. – Warren P Oct 11 '12 at 20:47

5 Answers5

5

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
  • 288,378
  • 40
  • 442
  • 569
  • ODBC is really your only choice here without a lot of re-work. – Tim Jarvis Aug 04 '09 at 07:10
  • 2
    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 Aug 04 '09 at 12:55
  • Nobody should be starting to use BDE who didn't start using it before 2002. – Warren P Oct 11 '12 at 20:47
1

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
  • 2,623
  • 3
  • 26
  • 28
1

You can use ADO without using Ado Components, by importing ActiveX Data Objects Library, but this will require more work.

Mohammed Nasman
  • 10,992
  • 7
  • 43
  • 68
0

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
  • 15,366
  • 2
  • 36
  • 53
0

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
  • 166
  • 2