View Single Post
  #1 (permalink)  
Old August 24th, 2003, 02:25 PM
GLCGLC GLCGLC is offline
Registered User
 
Join Date: Aug 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default ADO connection using password values

'I'm posting my password values from my form page to my connection_asp page but my values seem not to be passing through correctly to my connection_asp page to Open my db.
'It must be that I need my parameters for my ADO object edited in my connection_asp page but to what?

==================================================
'A) form parameters:
==================================================
[]
--------------------------------------------------
'a) - II form parameters:..
--------------------------------------------------

[sConn = Application("Conn.ConnectionString") & ";User Id=" & Request.Form("UserName") & ";PASSWORD=" & Request.Form("UserPwd") & ";"

        Conn.Open sConn
        If Conn.State = adStateOpen Then]

====================
'B) CONNECTION_PAGE:
==================================================

[Dim Conn
'Check to see if our Connection already exists if it does, don't do anything
If Not isObject(Conn) Then
    'If it doesn't set out variable to type ADO Connection Object
    Set Conn = Server.CreateObject("ADODB.Connection")
    With Conn
          "Server; Catalog; UserName; Password;"
        .ConnectionTimeout = 15
        .CommandTimeout = 30
        .CursorLocation = 3
        .Open Application("Conn_ConnectionString")
    End With]
--------------------------------------------------

'If somebody could help me with the proper syntax, I would greatly appreciate it.

GLCGLC



Reply With Quote