Setup And ADO

I've written a program that uses ADO, and I have used the Setup Wizard to create the setup program. The Setup Wizard recongnizes that the ADO dll (msado15.dll) is needed, but when I run the setup program on a machine without that dll already installed (which will be the case for most machines), I get the following error during setup:

"An error occured while registering the file 'C:\WINDOWS\SYSTEM\MSADO15.DLL'"

Then, of course, when the program is run and and attempts to create an ADODB.Connection object, the following error occurs:

"Run-time error '429': ActiveX component can't create object"

Should I be doing something extra when using the Setup Wizard so that msado15.dll will register properly (dependecies that I need to include maybe)?

Any input is appreciated. This is for school and my deadline is quickly approaching ;)

Thanks.
umkibbi0Asked:
Who is Participating?
 
bruncheyConnect With a Mentor Commented:
I would recommend using the MDAC setup that comes from microsoft.  You can get it from http://www.microsoft.com/data/mdac15.htm.  The problems that you are getting with the registration are dependency file things.  There is some file that needs to be registered on the PC before  MSADO15.dll can be registered.  So what I would recommend is to install the mdac15 setup first and then install your application.
0
 
umkibbi0Author Commented:
Perfect. That was far less painful and far more timely than I expected. Awesome.

Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.