write progamming connecting QTP to database sql? this is
question asked by interview? pls any answer this?
Answer Posted / raj
objConnect=CreateObject("ADODB.Connection")
objRecordSet=CreateObject("ADODB.RecordSet")
strConnection="Driver=SQL
Server","Server=LocalSQLServerName","Database=master","UID=s
a","PWD=sa"
objConnect.OPEN strConnection
strQuery= "select * from master"
objRecordset.Open strquery, objConnect
Thanks,
Raj
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
An action has both shared and local or associated to it and both have the same object in them. In the test which one will be considered?
Pls can anybody send me the Recent Technical and Interview Questions Which were asked in IBM(QTP)Automation PLZZZZZZZZZ
If object is not recognized by qtp but the object is standard object what is your approach?
What are the different recording modes?
Can any one explain me what is the procedure to connect the remote desk by using QTP 9.2 ?
any body can you help me what is the script to automate an comand promt
How to use Environment parameterization? Explain with an example.
What is difference between design time and run time data table?
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
Hi Sudhananda, plz send me the QTP framework with any diagram and PPTS . I want to switch to automatio, I done QTP from professional person, but he does not give me his knowledge properly. so pls help me Thaks send me on following address mirajkar.akash@gmail.com
i have two questions for regular expression :- Q1. I have date pattern eg-29/11/2011 29-11-2011 29.11.2011 Que- if any separator is there between date,month and year pattern should match else it should not match eg- pattern should not match in case of 2911-2011 Q2. let say i have a string and there is a number in between of that string eg.-Amount 30002.234 successfully credited to your account . now i have to match this pattern in such a way that even if decimal is not there pattern should match ,how i will do this using regular expression
What is the process of synchronizing qtp and aut?
I need to pull the data from the page which in row, column vice into excel sheet, how can it be done using QTP? eg: Name Dept xyz gdty i need the same data to be exported in excel sheet.
can any body plz help by sending the qtp docs and qtp ppt's? this is my mail id:murali.padeti@gmail.com
Explain different recording modes?