Thread: asp with access

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    egypt
    Posts
    16
    Rep Power
    0

    Question asp with access


    how can i provide the password for the database access using asp
    note that i'm using
    the recordset object
    set dbrs=server.createObject("ADODB.Recordset")
    dbrs.open "select *from table_name ","DSN",0,3
    and i don't like 2 use the connection object
    I NEED HELP IMMEDIATLLY

    Comments on this post

    • Gran Roguismo agrees
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    Canada - Egypt
    Posts
    60
    Rep Power
    12
    in your connection string
    where you have "DSN"
    use

    "DSN=DSN-Name;uid=login;pwd=password "

    I hope that's of any help

    Yasser
    www.WebsitesCreation.ca
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    egypt
    Posts
    16
    Rep Power
    0

    Thumbs up


    thank you very much
    and i realy hope 2 b friends my mail is
    faithiology@hotmail.com

IMN logo majestic logo threadwatch logo seochat tools logo