Forum Discussion

hshams's avatar
hshams
Occasional Contributor
9 years ago

sql server connection error "Provider cannot be found. It may not be properly installed."

Hi,   I am trying to connect to the sql server db using TestComplete 11, but I am getting an error: "Provider cannot be found. It may not be properly installed." Below is the code I am using, plea...
hshams's avatar
hshams
Occasional Contributor

I have added the ODBC Driver, you can look at the screenshot.

Below is the connection string I am using, I am still getting the same error.

 

var AConnection = ADO.CreateADOConnection();

AConnection.ConnectionString = "Provider=SQLDriver; Server = KEOUS-SQL\MSSQLSERVER01,1724; Database=K212.HrPayroll.ThamesValley.Hina;user id = sql.server;password=sql.server";

 

 

 

 

Kostja's avatar
Kostja
Contributor
9 years ago

Not sure if it might help you, but...

 

I am using the newer ODBC driver for oracle and my connection strings looks like this:

 

var Cmd = ADO.CreateADOCommand();
Cmd.ConnectionString = "Driver={Oracle in instantclient_12_1};Dbq=dbq;Uid=uid;Pwd=pwd;";

 

For Dbq i use the database configured in System DNS.

  • hshams's avatar
    hshams
    Occasional Contributor
    9 years ago

    This connection string works, I was not escaping the "\" too.

     

    var connectionString = "Provider=SQLOLEDB.1;Password=sql.server;Persist Security Info=True;User ID=sql.server;Initial Catalog=K212.HrPayroll.ThamesValley.Hina;Data Source=keous-sql\\mssqlserver01,1724";

     

    Thanks for the help.

Related Content