New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Others v
error in db connection

Thread Rating:
  • 2 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
error in db connection
KVK Offline
Member
***
Posts: 50
Threads: 0
Joined: Jul 2009
Reputation: 0
#2
Solved: 11 Years, 3 Months, 3 Weeks ago 07-13-2009, 10:00 AM
Hi

Try this

Initial Catalog is the database that u want to use..


Code:
sConstr="Provider=sqloledb;Data Source=192.168.1.2;Initial Catalog=DBtest;User ID=sa;Password=******;"
Set Db_Connection = CreateObject("ADODB.Connection")
Db_Connection.open sConstr
Db_Connection.Execute "select * from dummies"
Find
Reply


Messages In This Thread
error in db connection - by sarveshqtp - 07-11-2009, 01:10 PM
RE: error in db connection - by KVK - 07-13-2009, 10:00 AM
RE: error in db connection - by sarveshqtp - 07-13-2009, 01:26 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
Question JDBC connection for UFT Anjali09 0 3,640 10-05-2016, 02:19 PM
Last Post: Anjali09
  QTP connection to QC kirangoud 4 15,442 03-02-2012, 03:36 PM
Last Post: kirangoud
  QC-QTP Connection failure uma87 1 3,844 02-28-2012, 03:48 PM
Last Post: inborntester
  SQL Connection String with DSN geethwind 0 5,966 10-05-2011, 05:10 AM
Last Post: geethwind
  Connection to Salesforce Objects nipa1984 0 3,847 09-22-2011, 09:55 AM
Last Post: nipa1984

Forum Jump:


Users browsing this thread: 1 Guest(s)