odbc connectivity to oracle

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am taking over a database that has been somehow linked to an oracle
database that has forms, queries, reports etc, but I do not see the linked
tables in the tables area, but access knows where it's suppposed to ODBC to,
and I can't find where that is so I can change the TNS or password so that
the database can continue pulling data again. When I look at the tables
area, I see no tables at all, but the queries all have the table names and
the proper fields in them.

Can someone tell me what could be going on and how I can access where this
database is linking to so I can fix the oracle data and get the data again?

The error I am getting is when I click the form for this database, it said
ODBC connection to <oracle database driver> then names the driver Failed...
 
hi,
I am taking over a database that has been somehow linked to an oracle
database that has forms, queries, reports etc, but I do not see the linked
tables in the tables area, but access knows where it's suppposed to ODBC to,
and I can't find where that is so I can change the TNS or password so that
the database can continue pulling data again.
Click to expand...
First of all, ask to original programmer for an appropriate documentation.
When I look at the tables
area, I see no tables at all, but the queries all have the table names and
the proper fields in them.
Click to expand...
Extras/Options/Show hidden objects?


mfG
--> stefan <--
 
If they are pass-through queries then they have an ODBC Connect String
property, that may well be where your TNS and password are being stored. Look
in the Query properties for this.

Note that you must have an ODBC data source with the same name as the one in
the DSN part of the stored connect as that is used to get to the TNS entry.

HTH
John
 
Back
Top