write progamming connecting QTP to database sql? this is
question asked by interview? please give sql, pl/sql related
answer?pls any answer this?

Answer Posted / manish deshmukh

Set con = Createobject("ADODB.Connection")
set rs = Createobject("ADODB.recordset")
con.connectionstring="DSN=xyz;UID=abc;PWD=pqr;"
con.open
SQL="select * from manish"
Set rs=con.execute(SQL)

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to read a text file from QC using QTP. I would like to do something like this. But instead read a file from QC and NOT from my local drive. Set fso = CreateObject("Scripting.FileSystemObject") Set InputFile = fso.OpenTextFile("C:\test.txt", ForReading) Thanks

2746


Hi All, I Want To excute scripts batch without using QC .I need code for that Thanks Balaji

1312


How you can replace string in qtp?

568


For which type of projects the iterative model is not suitable?

1428


By using QTP can we record any log files written by the application which is in execution?

1469






How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s.

518


Are Shared ORs read-only?

621


How can I open a EXCEL file from QTP Resultviewer with reporter.ReportEvent function call. Example: Test files for details click "here". And clicking "Here" in the resultviewer will open a local EXCEL FILE.

1798


why text area checkpoints cannot used for web applications

1876


What is recovery scenario in qtp?

577


If a button named "CLICK" is recorded in low level recording mode , what will be the values stored for "name" property of that button in object repository ?

1735


how to find that tools work well with your existing system?

1399


if numbers are always changing write a script for that

3373


Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..

1510


I want to do QTP Certification what is the pattern of Question paper.

1737