R
rmcompute
A table was created which is connected to SQL Server through an ODBC
connection with a DSN file. The same DSN file is used in another database
for the same table and it works successfully. In this database the following
error is generated:
.......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 DSN file in this database and
how this can be removed ?
connection with a DSN file. The same DSN file is used in another database
for the same table and it works successfully. In this database the following
error is generated:
.......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 DSN file in this database and
how this can be removed ?