MDAC 2.6 not installing properly

[swoodring]

I installed MDAC 2.6 SP1 on my 2000 machine in order to get SQL server 7.0 to work properly on my machine. I'm trying to get installed on server which is on NT 4.0 SP6 so that when I save a DTS package on my 2000 machine and run it on the server it doesn't get the error client access ODBC driver not capable. I intalled MDAC 2.6 SP1 on the server but it doesn't look like its updating it. The install goes fine. I reboot but when I go into the ODBC connections and look at the driver for the client acceess it still has version 6.00.00.05 while my 2000 machine says 6.00.07.00

Any ideas on why its not updating. Can I just take the DWBODBC.DLL from my machine and copy it to the server?

 

[tlbroadbent]

I'm not familiar with DWBODBC.DLL. It is not a component of MDAC so far as I can tell. Check this Microsoft page for a list of MDAC 2.6 SP1 components. The page contains several links and lots of info about MDAC 2.6 sp1. It mentions some of the setup problems reported.

http://www.microsoft.com/data/MDAC26info/Manifest26sp1.htm

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.