ADODB.Connection 3706 Provider cannot be found. It may not be properly installed.,
-
I have made vb app that uses ADO 2.1 for connecting to an Access 2000 database. My app is working fine on every computer except One. As soon as the app connects to the database, it returns the following error: 3706, Provider cannot be found. It may not be properly installed., ADODB.Connection This computer has Win2k Pro SP4 / Access 2002 / MDAC 2.5 SP3 (I used Component Checker to find this out.) The user of this computer is pretty sure that Win2k SP4 was run by the Administrator of the computer so it is not a matter of privileges to access the drivers. The Micosoft Access Driver (ODBCJT32.dll) version is same as on my computer, where the app is working fine. I have tested my app on another computer that has Win2k Pro SP4 with MDAC 2.5 SP3...it works fine there. I have successfuly tested my app on different Windows OSes from (9x to XP pro) with MDAC ranging from "UNKNOWN" (as the Component Checker put it) to 2.7 Sp1/RTM. Unfortunately, the app is to be only used on this problematic computer. If anybody has encountered such a problem or has any ideas on this, pls do reply. Thanx in advance.
-
I have made vb app that uses ADO 2.1 for connecting to an Access 2000 database. My app is working fine on every computer except One. As soon as the app connects to the database, it returns the following error: 3706, Provider cannot be found. It may not be properly installed., ADODB.Connection This computer has Win2k Pro SP4 / Access 2002 / MDAC 2.5 SP3 (I used Component Checker to find this out.) The user of this computer is pretty sure that Win2k SP4 was run by the Administrator of the computer so it is not a matter of privileges to access the drivers. The Micosoft Access Driver (ODBCJT32.dll) version is same as on my computer, where the app is working fine. I have tested my app on another computer that has Win2k Pro SP4 with MDAC 2.5 SP3...it works fine there. I have successfuly tested my app on different Windows OSes from (9x to XP pro) with MDAC ranging from "UNKNOWN" (as the Component Checker put it) to 2.7 Sp1/RTM. Unfortunately, the app is to be only used on this problematic computer. If anybody has encountered such a problem or has any ideas on this, pls do reply. Thanx in advance.
Dear., I hope that access2000 is not able to access thro vb. So, u have to convet the database to the lower version. There is an option for that in the access. And then u make the connection b/w them. I hope its do good. Perhaps u had any error yet, then select the project-> there reference and select the microsoft Activex dataobject 2.0 library. Even After u had err then check the Data source name created is correct or not in the control pannel. bye Shanmuga Sundar.V
-
I have made vb app that uses ADO 2.1 for connecting to an Access 2000 database. My app is working fine on every computer except One. As soon as the app connects to the database, it returns the following error: 3706, Provider cannot be found. It may not be properly installed., ADODB.Connection This computer has Win2k Pro SP4 / Access 2002 / MDAC 2.5 SP3 (I used Component Checker to find this out.) The user of this computer is pretty sure that Win2k SP4 was run by the Administrator of the computer so it is not a matter of privileges to access the drivers. The Micosoft Access Driver (ODBCJT32.dll) version is same as on my computer, where the app is working fine. I have tested my app on another computer that has Win2k Pro SP4 with MDAC 2.5 SP3...it works fine there. I have successfuly tested my app on different Windows OSes from (9x to XP pro) with MDAC ranging from "UNKNOWN" (as the Component Checker put it) to 2.7 Sp1/RTM. Unfortunately, the app is to be only used on this problematic computer. If anybody has encountered such a problem or has any ideas on this, pls do reply. Thanx in advance.