montrof
asked on
VBA connection string to Oracle
I am trying to connect to Oracle through VBA. I have an ODBC connection setup and it works but when I try to connect through vba it will not connect. The ODBC connection is called BBProd and using the Oracle in OraClient11g_home1 Driver.
Here is my connection string vba
Thanks,
Montrof
Here is my connection string vba
cn.ConnectionString = "Driver={Oracle in OraClient11g_home1}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=MyHOst)(PORT=1506))" & _
"(CONNECT_DATA=(SERVICE_NAME=My_Service_Name))); uid=UID;pwd=Password;"
Thanks,
Montrof
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am getting the following error [Microsoft][ODBC Driver Manager] The Specific DSN contains an acrhitecture mismatch between the driver and Application
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER