I have a problem converting linked tables from Sybase to Oracle. The
problem
is that with Oracle the password prompt appears every single time the
table
is opened. When Sybase is used, the password prompt only is shown the
first
time a table is opened.
Configuration:
- MS Access 2003
- Windows XP
- Linked tables are created without checking the "Save Password" box in
each
instance.
I am in a conversion of the application to move it from linking from
Sybase
to start linking from Oracle.
Starting point:
I have a .mdb file that has linked tables. The tables originally were
linked to a Sybase database using Sybase's ODBC driver. When I open a
table
in data view, it prompts me for the username and password. After
supplying
the information, I am shown the data. Any subsequent openings of the
tables
to that same Sybase database are not prompted for the username and
password.
This is how I want it.
New point:
When I now have removed the tables and linked them again to an Oracle
database using Oracle's ODBC driver, the password prompt comes up EVERY
time
the table is opened--even if I have previously supplied it. Furthermore,
I
am prompted for the password two times (the prompt window comes up once, I
add the password, and then it appears again and I add the password
again--then the data view is displayed). This is NOT how I want it.
What is going on here? Why is Oracle's 10.2.0.3 ODBC driver not storing
the
password like the Sybase driver did?
|
