Clash for Oracle in OraClient 10g_home1 with Oracle RDB driver in VB.Net
893705Oct 11 2011 — edited Oct 13 2011I have a big problem here in my VB.Net (Visual Studio 2005). Earlier there was no problem in connecting to database using Oracle RDB driver but after I installed Oracle OraClient home 1, I can connect to the new Oracle database but on the other hand I couldn't connect to the other database using Oracle RDB driver.
There is no problem in the ODBC DSN test connection but I encountered this error message in my coding when i try to open the database using Oracle RBD driver.
Error message: "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
These are the connection strings for Oracle Driver for RDB and OraClient Home 1
Dim sConnString As String = "Driver={Oracle ODBC Driver for Rdb};" & _
"UID=rtr_user;" & _
"SVR=cbax07;" & _
"XPT=2;" & _
"CLS=TASTST_PSOFT;"
Dim sConnStr As String = "user id=rms_admin;password=rm5_adm1n;data source=CPORADEV;"
Pls advise what I need to do to overcome this problem. Your help is much appreciated. Thanks.