passwordless odbc connection

sathyaram_s · #1 (**permalink**) 07-19-11, 09:02

DB2 9.7 FP4 on windows

I have an ODBC data source defined for the SAMPLE database on the server.
I am opening MSAccess on the same server and trying to Import External Data.

When using the DSN Name SAMPLE, it pormpts for a userid and password.

Is it possible to configure the ODBC DSN not to prompt for a user and password, but use the log on credentials (like using a DB2 command window without password) ?

Thanks

przytula_guy · #2 (**permalink**) 07-19-11, 10:13

have a look at this page and look for trusted clients
Authentication methods for your server

Internet Services

Web Development

Digital Marketing

Consumer Tech