The specified provider was not found by ADO

[JohnBates]

Hello everyone -

I am using VB 6 against a SQL Server 7 db.

My app is simply a datagrid that is connected to an ADO data control.

It runs error-free on about 5 PCs..... but there is 1 machine that gives this error: " Run-time error 3706 ADO could not find the specified provider"

As always, I ran the setup.exe on this PC that was built by the Package & Deployment wizard.
I checked the setup.lst file (created by the P & D wizard) and verified that each of the .dlls, .ocxs exist on the PC. I even re-registered them, to be sure.
(There is a .TLB file used... is there a way to register it too?)

Still get the ADO could not find the specified provider error.

Management will not allow me to install VB onto this PC, so that is not an option.

Does anyone have ANY ideas that might enable this app to run on this PC?
Thanks, John

 

[Tinman]

I would check to make sure the db driver file is the right one.
And also make sure the connection string states exactly what driver it wants.
I have run into that type of problem with the ms sql server driver but not the sql 7.0 driver
Chad
tinman@thelandofoz.org

Tinman,

Welcome to OZ.

 

[MatsHulten]

Sounds like you need to install the latest version of MDAC to this PC.

Good Luck
-Mats Hulten