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
|
