Manoj.Srinivas

 Profile Answers by Manoj.Srinivas 

• Aug 27th, 2008

 

Use this piece of code:

Set mConnection = CreateObject("ADODB.Connection")
mConnection.Open "Provider=SQLOLEDB.1;Data Source=;Initial Catalog=<>CATALOG","USERNAME","PASSWORD"
set rs = CreateObject("ADODB.recordset")
rs.Open "select EMP_NAME from EMP where FileId='MANOJ'",mConnection
sString = rs.GetRows(1,0)

MS

dhanasekars

 Profile Answers by dhanasekars 

• Aug 28th, 2008

 

This is simlar to verification of data manually, instead here we use QTP to automate the process,
This is done by connecting to DB using ADODB connection, used Record set collection to manipulate the data

I think the other reply gives the code to connect to DB

Thanks,
Dhanasekar S