Please help

[snhuskey]

Hi

I am using an ado control to access data from a mdb. When i debug the program on the computer that has vb installed on it the program works fine, even when I compile it and then run it.

The problem is that when I install the program on another computer! I get an error with no error number that says "ADODC1 NO PROVIDER. it might have not been installed"

I'm not quite sure what that means. The only thing that I can come close to thinking what might be the problem is the drivers i choose during the packaging using the wizard. I chose ODBC direct, ODBC & Jetworkspaces, jet 2.0 &2.x. I don't even know if what i chose is correct.

But then again the drivers i choose during the packaging using the wizard probably are not even the problem. Oh man I need help lol.


Please Help

Thanks.

[JHausmann]

Try installing MDAC (only you know which one :) ) on the problem machine...

[snhuskey]

I thought that the packaging wizard detected you use ado or dao in your project it includes the mdac stuff. When I am running the install it does show that it is installing the data access components.

I am trying to download the new mdac from microsoft and as usuall the website is timing out.

[JHausmann]

I thought so too but I've had more than a handful of machines where the install didn't work because of MDAC...

[snhuskey]

Man. It didn't work. I downloaded the ado version of mdac sp1 and its doing the same thing.

[snhuskey]

I hope this little bit of information will help someone answer my question:


In my project I create a database in code using DAO. Once the database is created, I close the connection to it and then later during another point of the program I connect to the database it created with an ADO control not buy using code. The reason being is becuase I am still sorta new and I learning. But this is the way it is and it's too late for me to change that right now.

My question is why would I be able to connect to a database with the hand written code using DAO and why can't i connect to the database when I use an ADO control later on in the program?

Keep in mind that this program works perfectly fine until I try and install it on a machine that does not have VB6 installed.

please help

THanks

[snhuskey]

That when the message initially comes up it is not an error at all. It is only a message box with the title 'ADODC1' and with a message containing "Providor not found. It might now have been installed correctly."

When I try and manipulate the database it then throws a runtime error

[snhuskey]

Im gonna be in big trouble. Anyone have a clue?