what is the Vbscript to connect Database

Answer Posted / paayal

VBScript function that you can use to conncet to DB is
CreateObject. we have to create the connection object first
as ADODB and then we can use that connection object to open
the DB connection. Once the connection is open, we can run
SQL query by using a while..wend loop and can get the
derired results data into local data sheet

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you convert manual test cases to automated test cases?

761


How can i test an application like Google Earth.In my application data will be fetched from a oracle database based upon which graphs are generated..so these all are dynamic..how can i use qtp here..alongwith that how can i test the map generated by a satellite just like google earth..

1925


Which features or drawbacks of QTP lead to the upgrade for a newer version?

748


what type of automation is follwed in the project?

1699


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

1736


How to find the length of the string in qtp?

758


I want to grow as a Automation Engineer,Kindly help me in clearing my interview that what interviewer looks for as a Automation Engineer. I am having three years of experience in testing.

1807


Suppose you are using shared objects repository in your test and you want to split your present action? At that time shared object repository is single or it’s also splits?

874


How extensive or customized are the server logging and reporting requirements; are they considered an integral part of the system and do they require testing?

763


How to get Traceability matrix from TD?

917


how to create flat file datasubmission in qtp

2165


Subj: realtime example of Database check point, Can any one please detail on how the Database check point is utilized/implemented in a real time project. I already know how to make one by creating DSN/ODBC and writing the required query manually and other steps...I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thank you in advance

1985


What is the syntax to call one script from another?

764


I want to test my vb.net solution file using qtp. Does Qtp test only .exe file?

1931


terminal services client

1988