Forum Discussion

hina's avatar
hina
Contributor
5 days ago

Cannot connect to SQL Database using TestComplete

Hi,

I am trying to connect to SQL Database using TestComplete but it's giving me error: "Provider cannot be found. It may not be properly installed". Please help me how to connect to SQL Database, the code is below:

 

  function connecttosqldb()
{
  AConnection = ADO.CreateADOConnection();

// Specify the connection string
var AConnection = ADO.CreateADOConnection();

AConnection.ConnectionString = "Provider=System.Data.SqlClient; Server = <Server Name>; Database=<Database Name> ; user id = <User ID> ; password= <Password> ;TrustServerCertificate=True;";

// Suppress the login dialog box    
AConnection.LoginPrompt = false;    
AConnection.Open();

// Execute a simple query    
RecSet = AConnection.Execute_("SELECT * FROM RUN INFORMATION");


// Iterate through query results and insert data into the test log    
RecSet.MoveFirst();

while(! RecSet.EOF)    
{    
    
    Log.Message(RecSet.Fields.Item("RUN INFORMATION").Value); 
      
    RecSet.MoveNext();
}    
AConnection.Close();
}

Thanks,

Hina

3 Replies

Sort By
  • scot1967's avatar
    scot1967
    Regular Contributor
    4 days ago
    Copy Link

    Good deal!  Keep in mind that the sqloledb is legacy so support for it may be limited and may cease at some point.  You may also want to consider implementing "Integrated Security=SSPI" if you are on a domain using Windows Auth so you won't need to hard code user names and passwords.    Glad you got it working!

  • scot1967's avatar
    scot1967
    Regular Contributor
    5 days ago
    Copy Link

    I had to change my connection strings recently when we updated our server. (Provider='SQLNCLI11' quit working)  Provider=MSOLEDBSQL works for me.  Here I am connecting and doing an async call to a stored procedure.  The connections strings and ADO stuff will be what you want.
         

    // After all customers are created, run the CustomerSyncToSQLFilePro procedure
  let sProcSync = ADO.CreateADOStoredProc();
  sProcSync.ConnectionString = "Provider=MSOLEDBSQL;Data Source=ProdSQL;"+"Initial Catalog=TestingTeam;Integrated Security=SSPI";
  sProcSync.CommandTimeout = 120;

// Execute CustomerSyncToSQLFilePro stored procedure
  const syncResult = await execCustomerSyncToSQLFileProAsync(sProcSync);
  Log.Message(syncResult);

// Close the sync stored procedure connection
  sProcSync.Close();



    • hina's avatar
      hina
      Contributor
      4 days ago
      Copy Link

      Thanks scot1967 for the reply. I had to play around with my connection string to make it work. Here is my connection string that worked:

      Provider=sqloledb;Trusted_Connection=Yes;Data Source=<sql server name> ;Initial Catalogue= <db name> ;username= <username>; password= <password>