+- 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 Others (https://www.learnqtp.com/forums/Forum-UFT-QTP-Others)
+--- Thread: Getting error while connecting from qtp to oracle sql developer. (/Thread-Getting-error-while-connecting-from-qtp-to-oracle-sql-developer--8278)
Getting error while connecting from qtp to oracle sql developer. - Ritanjali Pradhan - 09-26-2014
Hi Ankur,
Thanks for sending the valuable information.
I have some doubts regarding database connection. while connecting from QTP to Oracle SQL Developer getting
issues
"The specified DSN contains an architecture mismatch between the driver and application"
"The setup routines for the oracle in oraclient10g_home1 ODBC driver could not be found. please reinstall the driver."
Could you please resolve this issue.
RE: Getting error while connecting from qtp to oracle sql developer. - vinod123 - 09-26-2014
Code:
Dim strCon
strCon = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=mysrv)(PORT=7001))" & _
"(CONNECT_DATA=(SERVICE_NAME=MYDB))); uid=read;pwd=read;"