Upgrade from SDAC 3.8 std to 4.0 pro

joepasquariello · Post by **joepasquariello** » Wed 16 May 2007 01:23

Hello,

I uninstalled SDAC 3.8 standard and installed 4.0 professional. When I open existing forms with TMSConnection objects, I get an "Invalid Property" error. Can anyone tell me what is wrong and how to work around this? Also, I cannot open the help files for 4.0. Is there a help application required?

Thanks,

Joe

Jackson · Post by **Jackson** » Wed 16 May 2007 10:54

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.

sean · Post by **sean** » Fri 18 May 2007 08:20

I just updated to sdac4 and have the same issue.

Open your *.dfm file in text editor

How can I do this? Delphi won't let me open it visually, due to the property errors.

If I use an editor like Ultraedit, I'm basically editing in hex mode, which seems dubious to me.

When the GUI complains, should I select Ignore or Cancel in such a case? If I select cancel, I cannot open the visual form.
If I do an ignore it wipes the SQL objects! except for MSConnection1!
I don't want to lose all my queries!

Jackson · Post by **Jackson** » Fri 18 May 2007 10:14

You can select Ignore, and then specify a desirable provider in the TMSConnection.Options.Provider property.

sean · Post by **sean** » Fri 18 May 2007 12:30

OK, but about the Query components that have disappeared, how can I avoid that, or get them back?

Jackson · Post by **Jackson** » Mon 21 May 2007 09:31

Follow the next steps:
1. Start your Delphi IDE.
2. Select the File->Open item in the main menu.
3. In the open dialog select "Delphi form (*.dfm, *xfm)" as file type and your dfm file as file name, and click the "Open" button. Delphi will open your dfm file in the text format.
4. 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 the provider in the Delphi IDE.
5. Save your dfm file and open the project.

sean · Post by **sean** » Mon 21 May 2007 22:42

Thanks, but after doing that, on re-opening the project, I still get "MSConnection1.Options.Provider: Invalid property value".

I did find the error though, I had:
object MSConnection1: TMSConnection
...
Options.Provider = 'prSQL'

And it should not be quoted, but rather:
Options.Provider = prSQL

(I mention this for reference for other readers..).

So thanks, problem solved,
I'm a step further after my upgrade