Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO could not find the specific provider, how do I fix this?

Status
Not open for further replies.

SwanSong4

MIS
Jul 19, 2001
9
US
I am new here, not the best in VB but I am trying to learn some. I am using ADO Data Control in my program and when I load it, or try to run it, it says "ADO could not find the speific provider." I've looked around some and did not find anything helpful. Any suggestions?
 
What connection string are you using?
could you provide your code so that I may tell you what's wrong wit it?

Eradic8or.
 
Check your ADODB.ConnectString value, make sure it was typed correctly (the server name if u put database on server, the database name if ur using MS Access, DSN file if ur use ODBC and so on)

usually, this is the source of that error.
 
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\JH_VB_DB\PAICdb.mdb;Persist Security Info=False
thats my connection string. Now when I click on build and select Microsoft Jet 4.0 OLE DB Provider and then click next and it says "Selected provider is not available. Check to see whether the driver was deleted"
Thats where I am at.
 
probably you don't have Microsoft Jet 4.0 OLE DB Provider drivers installed or probably you have an older version of them.
Get the latest drivers and install them.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top