Login

ritugoyal · 02-09-2010, 05:08 PM

Hi All,

Please can any body tell me the way to connect to SQL server through QTP!

Regards,
Ritu

manabh · 02-09-2010, 05:22 PM

Hi,
Try this out

Code:
objConxn.Errors.Clear
    With objConxn
        If .State = adStateClosed Then
            .Provider = "sqloledb"
            .Properties("Data Source").Value = DB_Server
            .Properties("Initial Catalog").Value = DB_Name
            If Len(Trim(DB_UserName)) = 0 And Len(Trim(DB_Password)) = 0 Then
                .Properties("Integrated Security").Value = "SSPI"
            Else
                .Properties("User Id") = DB_UserName
                .Properties("Password") = DB_Password
            End If
            .CommandTimeout = 0
            .Open
        End If
    End With

Login
Username:
Password:	Lost Password?
	Remember me

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	QTP License Server Upgrade	connect_harish	0	1,198	04-12-2019, 10:20 PM Last Post: connect_harish
	Connecting to Cognos TM1 Cube using UFT/QTP	anujkabra1985	0	2,002	10-09-2015, 01:51 AM Last Post: anujkabra1985
	Getting error while connecting from qtp to oracle sql developer.	Ritanjali Pradhan	1	3,696	09-26-2014, 02:06 PM Last Post: vinod123
	QTP 11.0 crash on batch execution from QC 11.0 after patch 15 installed on QC server	akothuru	0	2,545	02-13-2014, 03:27 PM Last Post: akothuru
	Not able to connect to Oracle SQL Developer	Paras Singh	0	7,095	05-30-2013, 01:25 PM Last Post: Paras Singh