DSN's user ID & password for SQL Server

This is a discussion on DSN's user ID & password for SQL Server within the ODBC forums in Framework and Interface Programming category; Hi, I setup a DSN which uses SQL as data source and chooses "With SQL Server authentication using a login ID and password entered by the user" option. The user ID and password are set in the DSN. When using ADODB.Connection to connect the SQL Server through the DSN at runtime, it needs user ID and password again. Any way to avoid this as the users shouldn't know the user ID and password of the SQL Server. How to use or get the user ID and password set with the DSN? Thanks, ybc...