Access 2007 connecting to Oracle 9i

[PacFreshAnthony via AccessMonster.com]

I created an Access db that connects to an Oracle db through pass through
queries, works fine on windows XP. On a new Windows 7 64 Ultimate machine I
cannot get Access to make a connection. I created File DSNs using the 32bit
Data Source Administrator. Created a new blank database to test the DSNs but
I have been getting connection errors. The error is TNS: could not resolve
service name error 12154.

Any help would be appreciated

Anthony

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200912/1

[AccessVandal via AccessMonster.com]

Maybe you need to install Oracle9 client into Windows 7 before you can create
a DNS for Oracle using the Oracle 9 Driver? You might want to post this to
Oracle forums regarding this as some of us may not know this will work with
Windows 7.

PacFreshAnthony wrote:
>I created an Access db that connects to an Oracle db through pass through
>queries, works fine on windows XP. On a new Windows 7 64 Ultimate machine I
>cannot get Access to make a connection. I created File DSNs using the 32bit
>Data Source Administrator. Created a new blank database to test the DSNs but
>I have been getting connection errors. The error is TNS: could not resolve
>service name error 12154.
>
>Any help would be appreciated
>
>Anthony

--
Please Rate the posting if helps you.

Message posted via http://www.accessmonster.com