ADODB fails to connect to server

Asked By Russell B Olson 0 points N/A Posted on - 08/20/2014

Hello,

Case of the ADODB connection provider not found error. I did some searches on the Internet for solutions to solve this error. Nothing useful and nothing that works was found on the Internet. Can anyone help me please to fix this error ? What this error means ?

Thank you !

Status

ALERT: The following error has caused the system to ABORT the processing needed to perform a save. Please note down the following error message and contact your Database Administrator.

********************ERROR MESSAGE************************

ERROR: An unexpected error occurred in MODULE: *6270014…..>>>

MAIN: 213 – ADODB.Connection: Provider cannot be found it. It may not be properly installed – Line no 38.

• Status: Open
• Question Views: 814
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Sharath Reddy 590495 points N/A #179629

ADODB fails to connect to server

I’m not sure if all instances of “ADODB.Connection: Provider cannot be found” is caused by the same fault but there is one case where the “provider” being asked is the older version, SQL Native Client or SQL 2005. To better analyze the issue, they tried testing the SQL server using the user ID and password but there was no problem.

The SQL Server Express 2008 was installed and all was ok. During the examination, they learned that the provider being asked was “SQLNCLI”. Here, the installed SQL Native Client was SQL Native Client 10.0 [SQL 2008] and not SQL Native Client [SQL 2005]. So, in this case, if you have SQL 2008, you need to download the standalone SQL Native Client.

Click SQL Native Client Standalone to download the installer and then install it on the computer. This will immediately remove the error and the application will work again.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 08/25/2014
• Question Category: Misc Software