Failed to create connection with DB

Asked By 10 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #174740

Failed to create connection with DB

qa-featured

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

Related Questions