February 20th, 2003, 02:04 AM
Connecting with SQL Server
Is it possible to connect to the SQL Server database from the ASP page without mentioning the User Name and password in the connection string.
I have heard of something like UDL ... Unified Data Linking ... I'm not sure what it is? and how it works? Can anyone tell me about it or if anyone know any site from which i can collect necceaary information . Please let me know ....
Pls mail me at : email@example.com
March 17th, 2003, 05:19 PM
I found an article for what you are looking for
You can put the username and password in an ODBC (DSN), and just reference it in the connection string as DSN=myodbc
also you can use a DSN-Less approach, wich is displayed in the article above mentioned.
I hope this helps