wretchard

MSADODC.OCX does not work on the clients, although it works perfectly on my development platform. The only known difference between my development machine and the users is that I have VB 6 Professional and MDAC 2.1 and 2.5 installed.

Any ideas?

cbrewer

Did you create a bat file with all the support files or package the program and install it on the clients so they have all the right libraries?

Chuck

wretchard

Thanks, Chuck, for taking the trouble to answer. I solved the problem shortly after I posted the question. The solution was in principle as you suggested.

I had installed MDAC 2.5 and consequently changed a whole slew of libraries on my system. By installing MDAC 2.5 at each of the clients, they acquired the same libaries and the problems vanished.

One caveat. If you install MDAC 2.5 on your development machine you may lose your ability to use some ADO 2.1 libraries. The solution is to install both MDAC 2.1 after 2.5 and you have them both.