|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 18th, 2008, 11:35 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
ODBC - Connecting MS Access to Oracle 10g
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! 
|
|
#2
September 19th, 2008, 09:51 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
ODBC - Connecting MS Access to Oracle 10g
hi,
dauster wrote: 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 --
|
|
#3
September 19th, 2008, 05:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
ODBC - Connecting MS Access to Oracle 10g
Hey, Stefan -
Everyone uses the same user name and password for the Access database - its a reporting database. "Stefan Hoffmann" wrote: hi, dauster wrote: 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 --
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
