Thread: Back end testing on SQL Server 2000

Hello friends

Can you just list out the procedure for doing backend testing by using sqlserver.

what I mean exactly is if iam using QTP tool ,how to connect to sql server and proceed with backend testing.

plz list out the steps.

waiting for answer

bye

Hi Aruna,

Try this code -

Dim objConnection
dim objRecordSet

Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")

objConnection.Open "Provider=SQLOLEDB;Data Source=atl-sql-01;" & _
"Trusted_Connection=Yes;Initial Catalog=Northwind;" & _
"User ID=fabrikam\kenmyer;Password=34DE6t4G!;"

--- Data Source would be the ServerName along with IP if required
--- Initial Catalog would be the Database Name

objRecordSet.Open "SELECT * FROM Customers", _
objConnection, adOpenStatic, adLockOptimistic

Cheers......