ODBC - Connecting MS Access to Oracle 10g

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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!


.

Relevant Pages

  • Re: Need your help [arguments for open source databases]
    ... >> I would like to have your opinions about open source databases versus ... >> in the universe of relational databases. ... The main difference between PostgreSQL and Oracle is manageability. ...
    (RedHat)
  • Re: SAHM considering database administration
    ... > I am a 36 year old stay at home mom, with eight years paid work ... Am I too old to start in this career? ... Work for places that use Oracle. ... You better _love_ relational databases. ...
    (comp.databases.oracle.server)
  • US-PA: Newtown - Junior to Mid-Level Oracle DBA
    ... Inc. is seeking an experienced junior to mid-level Oracle DBA to support multiple highly available transactional and data warehouse databases underpinning a 24x7 global web services application. ... Position responsibilities consist of both operational and application support primarily in a Red Hat Linux environment. ...
    (comp.databases.oracle.marketplace)
  • US-PA: Philadelphia Area - Junior to Mid-Level Oracle DBA (FT Permanent)
    ... Inc. is seeking an experienced junior to mid-level Oracle DBA to support multiple highly available transactional and data warehouse databases underpinning a 24x7 global web services application. ... Position responsibilities consist of both operational and application support primarily in a Red Hat Linux environment. ...
    (comp.databases.oracle.marketplace)
  • RE: Server Explorer & Databases
    ... As for the visual studio's database server explorer, ... oracle, visual studio generally use the OLD DB provider which is for Oracle ... and support of most general funcctionalitis in latest version of Oracle. ... #Server Explorer for Oracle Databases ...
    (microsoft.public.vsnet.ide)