SDAC on Vista (formerly known as Longhorn)

Otto · Post by **Otto** » Fri 09 Sep 2005 10:57

Hi!

Does anybody know something about why hangs up an application (Delphi7+SDAC 3.55) on Vista at Connect? No error message, just exits the program. It's working well on any other MS OS. Any idea?

Thanks in advance,
Otto

Ikar · Post by **Ikar** » Fri 09 Sep 2005 14:20

What version do you use, Standard or Trial?

Otto · Post by **Otto** » Mon 12 Sep 2005 08:05

I have a purchased SDAC (and ODAC also) version, probably standard. The installed version is v3.55.0.15.

Ikar · Post by **Ikar** » Mon 12 Sep 2005 11:35

Try to find sqlncli.dll file on your HDD. If you find it, then try to add 'Provider=SqLncli.1' string to TMSConnection.ConnectString

Otto · Post by **Otto** » Mon 12 Sep 2005 11:49

I have not found SQLNCLI.DLL. I have no isntalled SQL Express 2005 (neither SQL Server 2000 or MSDE). I'm trying to use a SQL Server 2000 on the LAN, not a local server...

Ikar · Post by **Ikar** » Tue 13 Sep 2005 06:52

Try to add 'Provider=SQLOLEDB.1' string to TMSConnection.ConnectString

Otto · Post by **Otto** » Tue 13 Sep 2005 11:23

It was already in the ConnectionString. If I run an another project compiled with SDAC, I got 'Wrong MDAC version' message, however, all of my apps using ADO are running well.

Ikar · Post by **Ikar** » Wed 14 Sep 2005 07:26

Please specify exact version of provider. You can see it in Info sheet of TMSConnection Editor

gkirkwood · Post by **gkirkwood** » Fri 22 Sep 2006 20:30

I got the SDAC SQL component to work on D2006 and Vista RC1 after getting the same error. This should work for D7 etc. What I did was :

Download the MDAC component checker from Microsoft's website. Run it and it will tell you where your MDAC components are (usually C:\Program Files\Common Files\System), and the version will be 6.xx. Go to a Windows XP machine and overwrite the Vista files with the same files from the XP machine (backup the originals first just in case it doesn't work for you). You might have to be logged in as an Administrator to overwrite them.

Eventually, when you run the component checker it will say version 2.8. Then the SDAC components will work.

This should help while Core Labs sort out the upgrade for us all.