Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Clash for Oracle in OraClient 10g_home1 with Oracle RDB driver in VB.Net

893705Oct 11 2011 — edited Oct 13 2011
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2011
Added on Oct 11 2011
1 comment
627 views