New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
How to connect QTP to SQL Server 2005

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to connect QTP to SQL Server 2005
loki.kl Offline
Junior Member
**
Posts: 3
Threads: 3
Joined: Apr 2009
Reputation: 0
#1
Smile  06-16-2009, 06:31 PM
How to connect QTP to SQL Server 2005Smile
Find
Reply
ursvinod Offline
Junior Member
**
Posts: 18
Threads: 0
Joined: Jun 2009
Reputation: 0
#2
06-17-2009, 01:52 PM
Find
Reply
Jackomcnabb Offline
Member
***
Posts: 52
Threads: 8
Joined: Dec 2008
Reputation: 0
#3
06-17-2009, 07:05 PM
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
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to identify an error page occurring in server in between the qtp run. aswini 1 2,207 05-04-2017, 03:52 PM
Last Post: Ankur
  Connect to IBM MQ using UFT 12.5 soumen 2 5,178 03-17-2016, 11:16 AM
Last Post: vinod123
  DB2 Connect connection with IE 11 SRP 1 3,075 12-18-2015, 12:41 PM
Last Post: vinod123
  Exe invoked through UFT is unable to access IIS and SQL Server service bkdevise 0 2,590 08-25-2015, 05:49 PM
Last Post: bkdevise
  “Cannot connect to 8822 (connection timed out)" Ikbal 0 2,506 12-08-2014, 11:38 PM
Last Post: Ikbal

Forum Jump:


Users browsing this thread: 1 Guest(s)