Printable View
I have a program that uses ADO to access a database. I install it on an older Windows 95 pc and get ADO could not find the specified provider.
Now I set the open statement for provider of Visual FoxPro Tables, MSADASQL, jet.4.0, but neither work. It works fine on other pcs, just certain ones that are older. Now, I tried manually registering msadasql.dll using regsvr32 and it failed, but doing it on the other pc's work just fine.
Anybody got any ideas????????
are you installing DCOM 98 and MDAC 2.1/2.5 on your win 9x clients?
I include them in my installation. Mdac automatically runs during setup, but dcom98 never does anything that I can see. Is it suppose to? For instance during setup without MDAC, the normal installation occurs. With MDAC the 2.1 installation runs and then the normal installation. Is DCOM98 that way also or?
OK, I went to the computer and installed DCOM98 separately and then reinstalled the program. It now works fine. Two questions still though:
1.) During the installation it says failed to register MSADASQL blah blah blah. I hit ok and it continues fine and the program works perfectly. Just curious why that is if you know.
2.) How come DCOM98 doesn't automatically install during installation? I had to add it to the setup files unlike MDAC that included itself. Is this a VB bug?
Thanks for any comments and thanks for helping. I had run DCOM98 on a few machines before separately and it kept saying a newer version is installed already, so I figured that it was silently installing in my program installation and never thought of installing it manually.