Hi,
I'm connecting oracle db from QTP using the following steps
Step 1: set conn=Createobject("ADODB.Connection")
Step 2: Srvname="Driver={Microsoft ODBC for Oracle}:Server=153.39.128.176;UID=abc;Password=password123"
Step 3:conn.open Srvname
Step 4:Set Rec = CreateObject("ADODB.Recordset")
Step 5:SQL="select count(*) from complianceprogramcode"
Rec.open SQL ,conn
In steps 3: it prompts for the error message "Format of the initialization string does not conform to the OLE DB specification"
I do not know the server name so gave the ip address of it.
Note: The oracle db is not connected at our end. It is installed in the client place remotely and we are accessing it through oracle client software
Please let me know the steps to the connect to database and retrieve data from table
I'm connecting oracle db from QTP using the following steps
Step 1: set conn=Createobject("ADODB.Connection")
Step 2: Srvname="Driver={Microsoft ODBC for Oracle}:Server=153.39.128.176;UID=abc;Password=password123"
Step 3:conn.open Srvname
Step 4:Set Rec = CreateObject("ADODB.Recordset")
Step 5:SQL="select count(*) from complianceprogramcode"
Rec.open SQL ,conn
In steps 3: it prompts for the error message "Format of the initialization string does not conform to the OLE DB specification"
I do not know the server name so gave the ip address of it.
Note: The oracle db is not connected at our end. It is installed in the client place remotely and we are accessing it through oracle client software
Please let me know the steps to the connect to database and retrieve data from table