How to connect SQL Server using TestComplete

[gvkr1985]

Hi,

I am trying to open SQL Server data base using my Testcomplete code-- VB Script...

Please Help...

[chrisb]

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;

}

[chrisb]

And for help building your connection string: http://www.connectionstrings.com/

[gvkr1985]

here is my code and it is not working...

Sub SQLServer

Set dbObj = ADO.CreateADOQuery()
dbObj.ConnectionString = mil-tfsprd-01
dbObj.Open()

End Sub

[chrisb]

You are not doing any SQL query on the database! In the example below I have hardcoded a generic SQL query in for you to modify, you would most likely want to add a parameter to your function and pass the query in, but this should do for now.

Sub SQLServer

Set dbObj = ADO.CreateADOQuery()
dbObj.ConnectionString = mil-tfsprd-01

dbObj.SQL = "Select * FROM yourcolumn WHERE avalue = something";
dbObj.Open()

End Sub

Your connection string looks odd, take a look at the link I posted above. That site has lots of information about how a connection string should be formatted. Check with your app developers they may well know the correct connection string if your app is having to connect to the database.

[Ravik]

TestComplete can use only 32-bit database drivers to connect databases. It does not support 64-bit database drivers. This is due to the fact that TestComplete is a 32-bit application, so it cannot load 64-bit modules into its process. Thus, in order for TestComplete to be able to access a database running on a 64-bit client machine, 32-bit database drivers must be installed on the machine.

If you use the Microsoft Open Database Connectivity Data Source Administrator tool to connect to a database on a 64-bit operating system, make sure that you use the 32-bit version of the tool, Odbcad32.exe (it is in the <Windows>\SysWOW64 folder). Otherwise, the tool will not be able to detect the needed 32-bit database drivers.

[jasmeenkaur27]

I tried the same code as stated:

var Qry1;

// Create a query

Qry1 = ADO.CreateADOQuery();

// Specify the connection string

Qry1.ConnectionString = "Driver={Microsoft ODBC for Oracle};Dbq= FILCODU2.uk.fid-intl.com:1701/FILCODU2;Uid=xx;Pwd=xx;"

// Specify the SQL expression

Qry1.SQL = "Select * FROM table WHERE COMM_CODE = 'COT'";

// Execute the query

Qry1.Open();

// Process results and insert data into the test log

Qry1.First();

while (!Qry1.EOF) {

Log.Message(Qry1.FieldByName("columnname").Value);

Qry1.Next();

}

// Closes the query

Qry1.Close();