How would you connect to database using vbscript ?

1.	How would you connect to database using vbscript ?
Answer» Although, QTP doesn’t give any built-in support to the database connectivity, VBScript language and ADODB objects helps in database connectivity. There are certain things that must be known before connectivity − Connection string of your server (will be differ from one server to another and can be build from www.connectionstrings.com) Database type Server name Database name Username Password To connect to the database, either; you can code the database connectivity command directly or you can use the SQLQuery tool provided by QTP.

Answer»

Although, QTP doesn’t give any built-in support to the database connectivity, VBScript language and ADODB objects helps in database connectivity.

There are certain things that must be known before connectivity −

Connection string of your server (will be differ from one server to another and can be build from www.connectionstrings.com)
Database type
Server name
Database name
Username
Password

To connect to the database, either; you can code the database connectivity command directly or you can use the SQLQuery tool provided by QTP.

Discussion