Connection string

Results 1 to 3 of 3

Thread: Connection string

  1. #1
    lgm Guest

    Default Connection string

    I am new to ASP and am trying to build my connection string based on values passed from another asp page. I am getting the user id and password from the other asp page. The "?" indicate the values being obtained from user.<BR><BR>strConnString = "Provider=SQLOLEDB; Data Source=SQL1; " & _<BR> "Initial Catalog=?; User ID= ?; password=?"<BR>

  2. #2
    MG Guest

    Default RE: Connection string

    How about this<BR><BR>Is getting values from a form using post method<BR>dim pw, uid, catalog, strConn<BR>catalog=request.form("catalog")<BR>uid= request.form("uid")<BR>pw=request.form("pw")<BR><B R>strConn = "Provider=SQLOLEDB; Data Source=SQL1; " & _<BR>"Initial Catalog=" & catalog & "; User ID=" & uid & ";password=" & pw & ";"<BR><BR><BR>

  3. #3
    lgm Guest

    Default RE: Connection string

    Thanks it worked perfectly.

Posting Permissions

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