G
Guest
An ODBC connection was created using SQL Server authentication. A linked
table was created using this connection and the data is successfully
accessed. When the database is closed and re-opened and the table is clicked
and the following message is displayed:
.......Login failed for user us\smithr
When OK is clicked on the above message screen, the SQL Server Login screen
is displayed with the Use Trusted Connection box checked and the user id,
smithr displayed. When the box is unchecked and the login information
existing in the DSN file is entered, it works. Can someone tell me why it
defaults to the trusted connection and not the information created when the
ODBC connection was created. Could it be that the password is not being
saved and if so, how is the password saved when creating the connection?
table was created using this connection and the data is successfully
accessed. When the database is closed and re-opened and the table is clicked
and the following message is displayed:
.......Login failed for user us\smithr
When OK is clicked on the above message screen, the SQL Server Login screen
is displayed with the Use Trusted Connection box checked and the user id,
smithr displayed. When the box is unchecked and the login information
existing in the DSN file is entered, it works. Can someone tell me why it
defaults to the trusted connection and not the information created when the
ODBC connection was created. Could it be that the password is not being
saved and if so, how is the password saved when creating the connection?