ADO CAN NOT FIND THE SPECIFIED PROVIDER

[pavinda]

I distributed the application using Package wizard. In my app i use microsoft access provider. I have a problem when i install my package. The error occur like this "ADO CAN NOT FIND THE SPECIFIED PROVIDER" . I 'd like to know what dll to fix thix error.

[chrisjk]

I beleive the provider is the string you put in the ADO control to tell it stuff about the DB you want to connect to. It looks something like this right?

Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source="C:\MyDB.mdb";Jet OLEDB :Database Password=MyPassword

Basically, it is saying something is wrong with that line. It could be when the app is installed on another computer, it is installed somewhere other than the path where you developed it. So VB is still trying to find C:\MyDB.mdb when infact it may be C:\MyApp\MyDB.mdb. Get the idea?

To solve, programatically change the connection string of the ADO Control to where the person installed it on there computer, like this

Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.Path & "MyDB.mdb;Jet OLEDB :Database Password=MyPassword"

This will access your database provided it is in the same folder as the executable.

Hope that helps!

(I HATE ADO BTW...whoever inveneted it should be shot!)

Good luck,

------------------
- Chris
chris.kilhams@btinternet.com
If it ain't broke - don't fix it :)

[chrisjk]

By the way, those happy look chaps on my previous post are there because this BB interprets a colon followed by a "D" as a smiley picture....perhaps there should be a way to turn that off... :)

[pavinda]

Thank you so much chrisjk. i already use it but
it's still error.