Ask a Question

How to connect SQL Server using TestComplete

gvkr1985
Occasional Contributor

How to connect SQL Server using TestComplete

Hi,

 

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

 

Please Help...

6 REPLIES 6
chrisb
Regular Contributor

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
Regular Contributor

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

gvkr1985
Occasional Contributor

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
Regular Contributor

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
Super Contributor

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.

 

 

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();

 

cancel
Showing results for 
Search instead for 
Did you mean: