Establishing SQL Connectivity

How to establish SQL Connection other than using QTP Wizard for SQL Connectivity?

vijay3080
Profile Answers by vijay3080 Questions by vijay3080
Oct 12th, 2009
1
1898

Showing Answers 1 - 1 of 1 Answers

vaibhavst
Profile Answers by vaibhavst Questions by vaibhavst

Nov 3rd, 2009

You can use the following code

'Creating objects of type ADODB
Set DBConn = CreateObject("ADODB.Connection")
Set RecordSet = CreateObject("ADODB.Recordset")

' setting up connection to the data base
DBConn.Open DRIVER={<Driver Name>};SERVER=<ServerName>;UID=<userid>; PWD=<password>;

'Checking whether connection is established or not
If DBConn.State = 1 then
DBConnection = Pass

Regards,
Vaibhav Tavarageri