Forum Discussion

akalogeropoulos's avatar
akalogeropoulos
Occasional Contributor
10 years ago

Connect to SQL Server via ADO object

I'm trying to connect SQL database using the ADO object. Everything installed on same machine, TC(v10.60), SQL Express 2014.

I'm getting the following error message.

Named Pipes Provider: Could not open a connection to SQL Server [53]

 

function checkDatabse()
{
  var AConnection;
  
  AConnection = ADO.CreateADOConnection();
  AConnection.ConnectionString = "Provider=SQLNCLI11;Server=myserver\SQLEXPRESS;Database=MyDatabase;Uid=User;Pwd=password;";
  AConnection.LoginPrompt = false;
  
  try
  {
    AConnection.Open();
    Log.Message("Database Opened")
  }
  catch(e)
  {
    Log.Message(e.message)
  }
}

 

 

 

 

Best regards,

Anastasios Kalogeropoulos 

2 Replies

  • TanyaYatskovska's avatar
    TanyaYatskovska
    SmartBear Alumni (Retired)

    Hi Anastasios,

     

    For me, this sounds as a connection issue on the SQL side. Community, what do you think?

    • cunderw's avatar
      cunderw
      Community Hero

      Error 53 means bad network path, so it something with that, not the script or TC.