Forum Discussion

LohaniNisha's avatar
LohaniNisha
New Contributor
12 years ago

Firebird Database Testing

Hello, My application runs with Firebird db. In current task i need to fire queries and check and compare the results. Please let me know how do i connect to the db and execute the task. ...
kumar_perlaa's avatar
kumar_perlaa
Contributor
12 years ago
Hello Nisha,

 

The below code snippet it might help you. By the way which DB you are using,Is it SQL Server 2008/2005 or Oracle 10g/11



Function DatabaseConnection()

{


//create ADO connection and Record set objects



objConnection = Sys.OleObject("ADODB.Connection");



objRecordset = Sys.OleObject("ADODB.Recordset");



param_record_set = Sys.OleObject("ADODB.Recordset");



var connectionString = "Data Source=PCACODBS08;Initial Catalog=DatabaseName;User ID=TestComplete;Password=testcomplete;Provider=SQLOLEDB ";//Setup the connection parameters  // Catalog=DatabaseName-->This is the name of DB, you will  get on DB Server



objConnection.Open(connectionString);



objRecordset.Open("Select Top 3 * from dbo.Main_Table where TC_HOST= 'TC_HOST' and in_use = 0 and is_active = 1", objConnection,adOpenStatic, adLockOptimistic,adCmdText);



--------------;



}



Regards,

Kumar