How to connect SQL Server using TestComplete

Look at the TC examples here: http://support.smartbear.com/viewarticle/56911/

Using the ADO object works fine for me. In the exxample below I pass in a SQL query. I have another function that builds SQL queries for me to pass into this..

function query (sqlQuery) {

var dbObj = ADO.CreateADOQuery();

dbObj.ConnectionString =  //your connection string here

dbObj.SQL = sqlQuery;

dbObj.Open();

queryResult = dbObj;

return queryResult;

}