what is the Vbscript to connect Database

Answer Posted / ajreddy

function Connect database
set con= create object("Adodb.Connection")
set rs=create object("Adodb.Recordset")
con.provider = "microsoft.jet.OLEDB.4.0" '@ For MS access
con.open="Path of Database"
rs.open "select * from xxxx", con
do until re.eof
end function

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format, if possible, kinldy mail PDF file to my mail-ID: ramakrishna908@gmail.com Regards, krishna.

1475


How many types of status are there?

597


How to import a test case present in ".xls" file to TD under a Test set?

755


Explain the concept of object repository and how QTP recognizes objects?

558


How we can import data from database?

657






what are all the fileds present in object repository?

1571


how can we preform retesting(DATA driven test) using function please gine the code for loginpage

2286


What are the different recording modes?

572


How may types of defects identify application or your currently working application?pls give me answer..

1523


What Folder Structure following in Keyword Driven Frame work?

2295


What is the virtual object?

655


How can I check if a environment variable exist or not?

547


How to Get the Run-time value of an object under that web app under Test to the local data table sheet of that Action?

3610


What is parameter in qtp?

686


How will you check a web application for broken links using qtp?

558