ODBC - Connecting MS Access to Oracle 10g

  • Thread starter Thread starter dauster
  • Start date Start date
D

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!
 
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)
Click to expand...
...this really sounds like your users don't have the CONNECT privilege to
TEST and DEV. Ask the responsible DBA's.


mfG
--> stefan <--
 
Hey, Stefan -

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

Stefan Hoffmann said:
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)
Click to expand...
...this really sounds like your users don't have the CONNECT privilege to
TEST and DEV. Ask the responsible DBA's.


mfG
--> stefan <--
Click to expand...
 
Back
Top