How to connect to data base?

Answer Posted / m.s.patil

You can write OLEDB script:

Set Con =CreateObject("ADODB.Connection")
ConString="Provider:SQLNCLI;Server=plantdev;DataBase=QAServe
r;UID=patil;PWD=password1"
Con.ConnectionString=ConString
Con.Open

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use breakpoints in QTP?

582


Can we call qtp test from another test using scripting. Suppose there are 4 tests and I want to call these tests in a main script. Is this possible in qtp?

658


Could anyone help me for the below scenario: i am using the descriptive programming for my account, in which we have to generate the contract in the MS-word. when i generate this doc, we need to click on enable macros to continue further. but i am unable to make qtp to click on this. if anybody faced the problem like this??? pls help to get it resolved? Thanks in advance

1409


how to download mercury qtp9.2 ny internet ?

2964


Explain the use of action split in qtp?

567






can u please explain what is the exact difference between qtp8.2 and 9.0

1681


In qtp, how you can use xpath to identify objects?

618


How can you send user defined messages to test report?

585


How the smart identification is used in real time?Please explain with an example

1549


your coming from electrical backgroung..but y ur coming to software side?

1389


How to use debug tools?

2198


I used child objects to get the no of weblist present in the weblist.now i need to select the items present in each weblist ?How to do so

2256


How do you know the location Id of an object if you know its index id?

589


I am getting an error "failed to open the XML checkpoint result viewer" in result window,after clicking on "View XML checkpoint results".Someone suggest me settings,if any...

1466


How to remove associated function library?

561