DB Login Help

Results 1 to 2 of 2

Thread: DB Login Help

  1. #1
    Join Date
    Dec 1969

    Default DB Login Help

    Does anyone know what the best method of creating a login with password that connects to only certain areas of a SQL server Database using ASP? We want to have the users to be presented with the logon screen and then if validated they would proceed to their secure region.

  2. #2
    Join Date
    Dec 1969

    Default RE: DB Login Help

    Create a simple user input form with user name and password field.<BR><BR>When you post this to the page with the recordset, on that page, when you open the database connection do this<BR><BR>set cn=server.CreateObject("ADODB.Connection")<BR>cn.O pen "DRIVER=SQLServer;SERVER=(Where the databse resides);UID=" & request.form("UserID") & ";APP=Microsoft Development Environment;DATABASE=(Put the database name here);TranslationOption=Yes",request.form("UserID" ),request.form("Password")<BR><BR>NOTE: Connection string is all 1 line<BR><BR>Open your recordset as normal and the permissions should be correct

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts