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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Help with Access connecting to a Oracle DB on a Windows 7-64bit workstation

TheVenksterMay 9 2014 — edited May 12 2014

Hello:

Here's my configuration:

OS: Windows 7-64bit

Oracle DBMS: 11g

I am trying to connect to a 11g DB from within Access.

I launched the ODBC Administrator from c:\windows\syswow64 directory as an Administrator (which I undertstand is the 32-bit version). When I tried to set up a new DSN, I encountered two problems:

1. The TNS Service Name dropdown has a slew of entries with funny characters. However, it did not include my TNS Entry.

2.  I manually entered my TNSName. It did ask me for the username and password. When I tested the connection, I got an error "ORA-12154"

Any help to resolve the issue will be much appreciated.

Venki

Comments

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

Post Details

Locked on Jun 9 2014
Added on May 9 2014
3 comments
1,786 views