Create a SQL DSN That Prompts for User Name and Password

[C0PP3R]

I am looking at creating a SQL DSN that when called will prompt the user for a user name and password. Any one know how i can accomplish this?

Thanks So Much

Copper

 

[tlbroadbent]

I would code a module to request the login and password and use them in the connect string. I would also avoid using DSN connections. Use SQL OLEDB and create DSN-less connections. If you must use a DSN, open the connection without a password. The connection will fail and the ODBC driver will then display a login screen. If you want to get the best answer for your question read faq183-874.

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm