02-26-2008, 12:51 PM
hi,
in my application i want to connect oracle database to QTP and execute the query.i tried with this code but failed to establish connection.
what all add-ins should be installed to connect database to QTP?
thanks
in my application i want to connect oracle database to QTP and execute the query.i tried with this code but failed to establish connection.
what all add-ins should be installed to connect database to QTP?
Code:
set conn=Createobject("ADODB.Connection")
Srvname="Driver={Microsoft ODBC for Oracle}:Server=DBserver,UID=abcd,Password=xyzz"
conn.open Srvname
Set Rec = CreateObject("ADODB.Recordset")
SQL="select PR_CODE from SCHED"
Rec.open SQL ,conn
thanks