Does qtp allows us to execute sql statements(like select..) with the help of any vb functions? winrunner does this with the help of db_connect(),db_execute_query(),db_write_records().

Interview Candidate
Feb 9th, 2006
2
3347

Showing Answers 1 - 2 of 2 Answers

asha

Feb 11th, 2006

Ya QTP has this facility
for this u r require to create dsn and then recordset for more information refer
QTP plus help file it contain code how to write SQL statment for the QTP
means "database connection" help

vknowth
Profile Answers by vknowth Questions by vknowth

Feb 12th, 2006

yeah, We can have through ADODB Engine for ex;code like this..
Function Connect_to_db()
    Set cnn = CreateObject("ADODB.Connection")
    Set rs = CreateObject("ADODB.Recordset")
    cnn.ConnectionString ="DRIVER={Oracle in OraHome92};SERVER=your server ;UID=username;PWD=password;DBQ=dbserver"
    cnn.open
    query = "select * from Employee"
    rs.open query,cnn
    rs.movefirst
    msgbox rs(0)

End Function