+- 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: unable to connect to oracle DB (/Thread-unable-to-connect-to-oracle-DB)
unable to connect to oracle DB - kamalteja - 04-01-2008
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