Upgrade 3 Std to 4 Pro: Can't open old projects

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 3
Joined: Fri 10 Mar 2006 10:34

Upgrade 3 Std to 4 Pro: Can't open old projects

Post by clevercom » Thu 26 Apr 2007 07:26

I made a upgrade from 3 std to 4 pro with BDS2006.
After that I cant't open projects that use version 3 objects. I get a error message like "Error reading from MSConnection1->Options.Provider: unknown value" (translated from german).
If I press ignore, the form is away.

New projects are not affected.

I've tried the trick with the /force to install, but it doesn't help.

Please give me a hint.


Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Thu 26 Apr 2007 07:55

Open your *.dfm file in text editor and replace "Options.Provider = 'SQLOLEDB.1'" with "Options.Provider = prSQL" or,
if you use SQL Native Client as an OLE DB provider, replace "Options.Provider = 'SQLNCLI.1'" with "Options.Provider = prNativeClient".
You can also just remove this string and assign a provider in Delphi IDE.

Post Reply