ODBC - Connecting MS Access to Oracle 10g

[dauster]

All workstations have the exact ODBC connections to the 3 Oracle databases
(Prod, Test, Dev) using the Oracle in OraClient 10g_home1 driver. Using my
workstation, I can view/execute tables and stored procs in all 3 Oracle
databases in MS Access. For the other users, they can only view/execute
Oracle tables and stored procs in Prod. They get an error message trying to
view/execute objects in the other Oracle databases:
ODBC - connection to <database> failed.
[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identified
specified (#12154)[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLConnectAttr
failed (#0)

On our laptop, it cannot view/execute objects in any of the 3 Oracle
databases.

HOWEVER, when I test the connections to the 3 databases in ODBC from any
machine, the test is successful. I am at a lost. Any help will be
appreciated!!!

Thanks!

 

[Stefan Hoffmann]

hi,

For the other users, they can only view/execute
Oracle tables and stored procs in Prod. They get an error message trying to
view/execute objects in the other Oracle databases:
ODBC - connection to <database> failed.
[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identified
specified (#12154)[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLConnectAttr
failed (#0)

...this really sounds like your users don't have the CONNECT privilege to
TEST and DEV. Ask the responsible DBA's.


mfG
--> stefan <--

 

[dauster]

Hey, Stefan -

Everyone uses the same user name and password for the Access database - its
a reporting database.

hi,

For the other users, they can only view/execute
Oracle tables and stored procs in Prod. They get an error message trying to
view/execute objects in the other Oracle databases:
ODBC - connection to <database> failed.
[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identified
specified (#12154)[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLConnectAttr
failed (#0)

...this really sounds like your users don't have the CONNECT privilege to
TEST and DEV. Ask the responsible DBA's.


mfG
--> stefan <--