MS SQL not found

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
RandySill
Posts: 14
Joined: Sat 21 Oct 2006 11:42

MS SQL not found

Post by RandySill » Sat 27 Jan 2007 13:28

My SDAC all of the sudden cannot connect to SQL Server. Enterprise Manager and all my other SQL tools are connecting ok, but I get the "MS SQL not found" error when using SDAC. I searched the source for this error and it looks like when created the OLEDB control, it fails. Did my OLEDB get messed up? I tried re-installing MDAC, re-installing SQL Server, nothing helps. What could cause this? Windows XP SP2, SQL Server 2000 Dev Edition.

Randy
Top
RandySill
Posts: 14
Joined: Sat 21 Oct 2006 11:42

Post by RandySill » Sat 27 Jan 2007 13:48

Took some work, but I got if figured out. XP SP2 comes with MDAC 2.81 and you cannot install 2.81 from the MS download. I googled for how to repair MDAC on XP and there were some steps to follow. It worked as soon as it had repaired itself. It's a process of right clicking the MDAC.INF in your Windows\Inf folder and selecting Install...then it walks through the files needed which most can be found in Windows\servicepackfiles\i386.

Thanks.
Top
Post Reply

Return to “SQL Server Data Access Components”