ODBC setup

I'm trying to setup linked tables through ODBC connection to an Oracle
database.

I'm having some difficulty connecting as it simply hangs, and I have
to shut down access.

I figure it must be a problem with DNS because I was able to make it
work when I had Access 2003 and now with 2007 it fails.

I checked my tnsnames entry and used the correct server name,
username, and password under: start/settings/control panel/
administrative tools/Data Sources(ODBC)/File DSN(tab), but in the same
place under the "System DSN" tab I'm not sure what to put.

I tried to add a Microsoft ODBC for Oracle data source, but what is
the "Data Source Name", and "Description". I see those entries in my
tnsnames entry for that particular database, but it is in the format:

OUO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bob.bobbing.com)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ouu1.onstar.gm.com)
)
)

Any Ideas on what to do from here?
.

Relevant Pages

  • Re: Microsoft Query
    ... alone and that Oracle is aware of the issue. ... > deleting data in the database. ... >> I can't speak directly to your problem with MS Query, ... >>> from a Unix based database, via an ODBC connection. ...
    (microsoft.public.excel.programming)
  • Access 2000 Ctirix odbc problem
    ... Recently the application was moved to a citrix environment. ... citrix environment is one copy of the mde and the oracle odbc driver to ... connect to the database. ... sharing the ODBC connection or what else might be causing it? ...
    (comp.databases.ms-access)
  • Re: Suggestion for DB Connection
    ... Joe wrote: ... > I am using Visual Basic 6.0 and Oracle 8 as database for my project. ... > connect to the database using Visual basic 6.0 is it ODBC connection ...
    (microsoft.public.vb.general.discussion)
  • Slow ODBC Connection
    ... I’m using front-end in MsAccess 97 and an Oracle 9i database. ... My ODBC connection is very, ...
    (microsoft.public.access.externaldata)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)