Skip to Main Content
Forums

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!

ODBC connection failed after Oracle upgrade to 11g

user3477264Feb 1 2016 — edited Feb 3 2016

I am running into a strange situation.

I use Microsoft Access 2013 to link to a table in my Oracle environment. I have the 11.2.0 32 bit client installed. Previously, I could link to our 10g databases without any issues. After our production server was upgraded, I can no longer connect to the production database which is now 11g. I am using the Oracle in OraClient 11g as the ODBC driver which still works fine for the the 10g databases, but I can no longer connect to the 11g database. When I test the ODBC connection in Control Panel, I get a successful connection. It appears that something is not working with MS Access 2013 after the upgrade. I checked with a fellow co-worker, but they are no seeing the same issue. I can ping the server with tnsping and get a successful reply.

Here is a screenshot of the error message:

ODBC-Fail.jpg

The driver is the SQORA32.DLL is from 4/2/2010.

Any help would be appreciated!

Thanks!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 2 2016
Added on Feb 1 2016
#odbc, #oracle, #windows, #windows-and-net
2 comments
1,837 views