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!

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
#odbc, #windows-and-net
3 comments
1,788 views