akalogeropoulos
10 years agoOccasional Contributor
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