how i will connect oracle or microsoft acess database
through manually written Script

Answer Posted / sashikanth

DIM ADDCON
DIM RECSET

SET ADDDCON = CREATEOBJECT("ADODB.CONNECTION")
ADDCON.OPEN "DSN= ;UID= ;PWD= ;"
SET RECSET = ADDCON.EXECUTE("SELECT.....)
WHILE RECSET.EOF
.........
.........
WEND
SET ADDCON = NOTHING
SET RECSET = NOTHING

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to creating an output value using quicktest professional?

542


what is the difference betn QTP 8.0 AND PREVIOUS VERSION

1953


How does QTP identify an object?

614


Thanks....But can u tell me how i use the QTP for GIS with one Example...

1429


How do I lauch my test website using code from qtp in different environmet, uat and PPTE?

1461






How to replay a script in qtp?

614


what is the frame work in J-meter?

1603


Explain the types of properties that quick test learns while recording?

562


can any boby tell me what is method or steps to connect the remote desk top by using QTP 9.2 version?

1625


How can we use the "CreateObject("Shell.Application")" in QTP and what is the definition and purpose of it?

3058


How smart identification works in qtp ?

576


How to creating an output value using quicktest professional (qtp)?

568


Could you please any one give code for the following ? Scenario : Suppose a excel file contains 10 records and earch have 5 fields. how can i input this excel file for datadrive wizard ? Please explain

1463


What is the use of Debug Viewer?

1490


Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji

1378