Thursday 14 March 2013

how to connect to database in QTP

Example - Below Code will connect to database in MS-access and fetch data from std table 

Option Explicit 
Dim con,rs

 Set con=createobject("adodb.connection") 
Set rs=createobject("adodb.recordset") 

con.open "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydb.mdb;Uid=Admin;Pwd=;" 
rs.open "select * from std",con 

Do while not rs.eof 
print rs.fields("c1") 
rs.movenext 
Loop

 'release memory 
Set rs= nothing 
Set con= nothing

No comments:

Post a Comment

Please Leave your reply. We value your feedback and inputs

Best QTP Books

Everything About QTP

Hello Friends,
You can find QTP study material, Multiple choice questions (mcq), QTP question bank, QTP question papers, QTP notes, QTP questionnaire, scenario based QTP interview questions, QTP tutorial and QTP training on this site.

If you are a fresher or experienced QTP professional with (1/2/3/4) years of experience, this blog is just for you.