Access connecting to Oracle

message from Jason. on 24 May 2004

I have created an access database to query an Oracle
Database. When I distributed this access database to other
members of my team, they received the following error
message upon trying to open it,

ODBC--Connection to '{Oracle in Oracle}-V42MR3' failed,

where V42MR3 is the name of the Oracle Service.

On my PC, I connect to Oracle using the folder Oracle in
Oracle. Other users connect to Oracle via 'Oracle in
Orant'.

Can someone please tell me how I can change the path on
the Access Database in order to allow me connect to Oracle
regardsless of Folder name?

Your help will be appreciated.
Thanks,

Jason.

=?Utf-8?B?QmVySGF2?= replied to Jason. on 24 May 2004

Hi Jason,

I guess you have linked the tables/views from your Oracle database using ODBC and have setup on each computer the ODBC connection the same way incl. same 'Microsoft ODBC for Oracle' driver version.

Did you check the tnsnames.ora file that the Oracle database is named the same way, same address, etc? Or are there several of them around on your colleagues PCs, then you will have to check in the registry which one is used by Oracle and have to amend either registry or the used tnsnames.ora.

Usually it should not make any difference in which directory the Oracle software is installed.

HTH
Bernd

anonymous replied to =?Utf-8?B?QmVySGF2?= on 25 May 2004

Hi,

I have checked the TNSNAMES file and that all seems ok.
Any other suggestions?

Thanks,

Jason.

database using ODBC and have setup on each computer the
ODBC connection the same way incl. same 'Microsoft ODBC
for Oracle' driver version.
database is named the same way, same address, etc? Or are
there several of them around on your colleagues PCs, then
you will have to check in the registry which one is used
by Oracle and have to amend either registry or the used
tnsnames.ora.
directory the Oracle software is installed.

Pieter Wijnen replied to anonymous on 25 May 2004

I have experienced problems with different ODBC versions through the years
mainly fixed by removing the 32-bit entries from %WINDIR%\ODBC.ini
also there are situations where Microsofts ODBC will work & certain Oracle
ODBC versions won't - and vice versa

HTH

Pieter

<anonymous@discussions.microsoft.com> wrote in message
news:11c9101c4422c$24ba2630$a401280a@phx.gbl...

Archived message: Access connecting to Oracle (MS Access Database)