reinstall mssql ODBC drivers

[tswitz00]

A while agao I had the blue screen of death and I am pretty sure it messed up some registry entries and now my ODBC admin cant find any drivers so I am trying to reinstall them but I cant seem to find them anywhere.

 

[erikhertzel]

Try installed the latest MDAC (2.8) which will give your what you are after:

http://www.microsoft.com/downloads/...FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c

Best regards.

Erik

 

[tswitz00]

I downloaded and ran from link and I got this error

"MDAC 2.8 RTM is incompatible with this version of Windows. All of its features are currently part of Windows."

Currently I am running XP pro SP2

 

[erikhertzel]

That should work since you are on XP SP2, but try this:

http://www.microsoft.com/downloads/...95-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en

 

[tswitz00]

Tried new link and got this error:

"Fatal Setup Error
This setup does not support installing on this operating system

 

[erikhertzel]

OK,

Well, try this link:

http://msdn.microsoft.com/data/mdac/downloads/default.aspx

This should definately point you in the right direction.

 

[KenB]

Download the MDAC Utility: Component Checker from the previous post. This will report on the MDAC level and files. You may need to reinstall the SQL app. instead.

Ken

 

[tswitz00]

I actually got it figured out. It turned out to be a registry issue, for some reason the list of drivers was deleted from my registry so I just exported them from another station in my office and imported them into mine and it worked fine.