Access connecting to Oracle

  • Thread starter Thread starter Jason.
  • Start date Start date
J

Jason.

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.
 
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

HT
Bernd
 
Hi,

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

Thanks,

Jason.
-----Original Message-----
Hi Jason,

I guess you have linked the tables/views from your Oracle
Click to expand...
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
Click to expand...
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
Click to expand...
directory the Oracle software is installed.
 
I have experienced problems with different ODBC versions through the years
mainly fixed by removing the 32-bit entries from %WINDIR%\ODBC.ini
you might have to bite the bullet and use the same OraClient/ODBC version on
all machines though ...
also there are situations where Microsofts ODBC will work & certain Oracle
ODBC versions won't - and vice versa

HTH

Pieter
 
Back
Top