#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    India
    Posts
    3
    Rep Power
    0

    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 : sandoo4925@hotmail.com
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2002
    Location
    Mexicali Mexico
    Posts
    23
    Rep Power
    0
    I found an article for what you are looking for

    http://www.4guysfromrolla.com/webtech/070699-1.shtml

    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

IMN logo majestic logo threadwatch logo seochat tools logo