dim con,cmd set con=createobject("adodb.connection") set com=cr

How to retrieve the data from database?

Question Posted / asn

6 Answers
12336 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / asn

dim con,cmd
set con=createobject("adodb.connection")
set com=createobject("adodb.command")
con.open"provider=sqloledb.1 or ora
oledb.1;server=servername;uid=uid;pwd=password;database=data
sourcename"
cmd.activeconnection
cmd.execute"select*from tablename"

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Hi. please provide license key for QTP 9.2, I have windows XP on my machine Thanks in Advance, moreshwar

3189

Tell me one scenario, the complex functionality you have automated in your project?

1938

Hi there, I've installed a trial version of QTP to see if it works with my product but I cant automate selecting windows from a tree view? Can anyone give me any pointers? Many Thanks

1823

In an interview, what r the general questions asked in SQL which is realted to testing ?pls give me anwser to this question?

1954

Explain the benefits of quick test pro(qtp)?

942

In qtp, how you can remove the spaces from string?

923

what r the verstions from 1st to present (verstions) of mercury tools (like winrunner,QTP,Loadrunner) ? Chandana

1884

How is recording done when a application is over lapping the QTP application it gives a message object not recorded

1983

How to handle the exceptions using recovery secnario manager in quicktest professional?

1073

Hi All, we are using QTP Automation Scripts to test SAP. I recorded QTP Automation Scripts in English-based SAP GUI. Now we have to test a French-based SAP sytem and use the same scripts. The QTP scripts are failing when executed on the French-based SAP System due to Object Recognition Issues. What can we do? Do I re-record the scripts in the French-based SAP system?

2886

What are the types of properties that quick test learns while recording?

979

what is object and child object.. explain ..if possible give some example for better understanding ..

1940

How many number of actions possible in qtp?

991

I am sathish , i want to test the Application of JIL.org ,Mobile Emulator ,by using QTP10.0. I am trying to do testing on that Application , but Child Objects are not identified by the QTP. Please can any one help me

1850

How do you send email with attachment from outlook using qtp ?

968