+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How to connect QTP to SQL Server 2005 (/Thread-How-to-connect-QTP-to-SQL-Server-2005)
How to connect QTP to SQL Server 2005 - loki.kl - 06-16-2009
How to connect QTP to SQL Server 2005
RE: How to connect QTP to SQL Server 2005 - ursvinod - 06-17-2009
Hi
refer to this site
http://www.connectionstrings.com/
RE: How to connect QTP to SQL Server 2005 - Jackomcnabb - 06-17-2009
Code:
DBType="sqlserver" Then
UID = GetLocalParameter("sqlserver.user")
PWD = GetLocalParameter("sqlserver.password")
SERVER= GetLocalParameter("sqlserver.servername")
DATABASE= GetLocalParameter("sqlserver.servername")
DATASOURCE=GetLocalParameter("sqlserver.host")
PORTNUM=GetLocalParameter("sqlserver.port")
set conn=Createobject("ADODB.Connection")
Srvname= "PROVIDER=SQLOLEDB;DATA SOURCE="&DATASOURCE&","&PORTNUM&";UID="&UID & ";PWD="&PWD&";DATABASE="
conn.open Srvname