MDAC 2.8 and Visual Studio
As I told earlier, I have to build C# components for a BizTalk 2004 project. One of the prerequisites of BizTalk 2004 was to install MDAC 2.8. So I did and from that moment on, I could not access my SQL server anymore. Some of the problems I had:
- I could not view the information in my tables in SQL Enterprise manager
- In Visual Studio, I was no longer able to add a new data connection in the server explorer.
- In Visual Studio, I was also not able to browse to my SQL server.
- And last, but definitely not least, when I tried to check-in/out sources from Visual Source Safe, I got an error message about a procedure that could not be found!
This really pissed me off. Eventually I traced it to one DLL, MSDART.DLL. This DLL comes with MDAC. The version on my machine was 2.7.????, which was odd since I had installed MDAC 2.8. I then asked a colleague to send me his version of MSDART.DLL. All the above problems disappeared after installing that DLL on my machine.
Still wonder why re-installing MDAC didn't fix it.