2003 Server and MDAC

[mharlan]

Hi All,

I had built a VB6 ActiveX DLL referencing MDAC 2.8 on Windows 2000 and recently upgraded to Windows 2003. Now, whenever I try to run my component in the VB6 IDE the "new ADODB.Connection" statement does not work.

Any ideas?

TIA,

Michael

[nmX.Memnoch]

Did you do an upgrade install? If so, sometimes MDAC doesn't correctly upgrade with Windows. We had this issue on our old database cluster. To fix the issue you'll need your Server 2003 CD and follow these instructions:

• Open Windows Explorer and go to C:\WINDOWS\inf\.
  
• Locate the mdac.inf file and right click on it.
  
• Select Install from the context menu.
  
• It'll start the MDAC installation process. This is where you'll need your Server 2003 CD.
  
• When it's finished reboot the server.
  

Edited September 17, 2007 by nmX.Memnoch