Devart Forums

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

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.