Page 1 of 1
SDAC on Vista (formerly known as Longhorn)
Posted: Fri 09 Sep 2005 10:57
by Otto
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
Posted: Fri 09 Sep 2005 14:20
by Ikar
What version do you use, Standard or Trial?
Posted: Mon 12 Sep 2005 08:05
by Otto
I have a purchased SDAC (and ODAC also) version, probably standard. The installed version is v3.55.0.15.
Posted: Mon 12 Sep 2005 11:35
by Ikar
Try to find sqlncli.dll file on your HDD. If you find it, then try to add 'Provider=SqLncli.1' string to TMSConnection.ConnectString
Posted: Mon 12 Sep 2005 11:49
by Otto
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...
Posted: Tue 13 Sep 2005 06:52
by Ikar
Try to add 'Provider=SQLOLEDB.1' string to TMSConnection.ConnectString
Posted: Tue 13 Sep 2005 11:23
by Otto
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.
Posted: Wed 14 Sep 2005 07:26
by Ikar
Please specify exact version of provider. You can see it in Info sheet of TMSConnection Editor
Posted: Fri 22 Sep 2006 20:30
by gkirkwood
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.