Failed to create connection with DB

Asked By Arthur C Crivello 10 points N/A Posted on - 09/21/2013

Hi,

I have installed SQL server 2008 R2 on my Win 7 OS and restored my DB but getting the following error message trying to create a connection. I have searched for a solutionto fix this issue but I am unable to find anythingresolving the matter. I need an expert’s advice so please provide a proper solution. It would be appreciated. Thanks in advance.

 

Error

Failed to create connection. Check your Connection String and BD Settings

Exception detail:

0x800A0E7A-

Source:            ADODB.Connection

Description:     Impossible de trouver le fournisseur. II est peut etre mal installe

HelpFile:         C:windowsHELPADO270.CHM

HelpContext:  1240655

In:

J:DropboxAutoHotkeyLibIsNullahkDBALibDataBaseADO.ahk

Line:    27

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

• Answer Accepted: No
• Question Category: Database

Answered By Quinn Poon 0 points N/A #174740

Failed to create connection with DB

Hello Arthur,

Good Day!

To resolve this problem, follow this method:

· In your ADO connection string, avoid using “Persist Info” keyword

·  You need to add OLEDB_SERVICES registry entry

Reminders: Create OLEDB_SERVICES value in the registry keys of providers that only support COM aggregation.

I hope this is help you.

Regards,

Quinn Poon

About Quinn Poon

Questions
0

Answers
30

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 09/23/2013
• Question Category: Database