Hi,
I am trying to create a system DSN for the asp pages, however, I am getting to following run time error on the front end (browser):
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/form/LoginProcess.asp, line 46
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
GET /form/LoginProcess.asp
HERE is my ASP code where the problem may be:
Dim strUserName
Dim strPassword
Dim strSQLStatement
Dim DataConn
Dim rsPasswordFile
Dim cmdDC
Dim tempInt
strUserName = Request.QueryString("UserName"
strPassword = Request.QueryString("Password"
strSQLStatement = "Select * from LoginInfo where UserName = '" _
+ strUserName + "' and PasswordFld = '" + strPassword + "'"
set DataConn = Server.CreateObject("ADODB.Connection"
DataConn.Open "DSN=HeminiWebDSN"
Set cmdDC = Server.CreateObject("ADODB.Command"
cmdDC.ActiveConnection = DataConn
cmdDC.CommandText = strSQLStatement
cmdDC.CommandType = 1
set rsPasswordFile = Server.CreateObject("ADODB.Recordset"
rsPasswordFile.Open cmdDC, , 0', 1
Thank you for your help in advance!
I am trying to create a system DSN for the asp pages, however, I am getting to following run time error on the front end (browser):
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/form/LoginProcess.asp, line 46
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
GET /form/LoginProcess.asp
HERE is my ASP code where the problem may be:
Dim strUserName
Dim strPassword
Dim strSQLStatement
Dim DataConn
Dim rsPasswordFile
Dim cmdDC
Dim tempInt
strUserName = Request.QueryString("UserName"
strPassword = Request.QueryString("Password"
strSQLStatement = "Select * from LoginInfo where UserName = '" _
+ strUserName + "' and PasswordFld = '" + strPassword + "'"
set DataConn = Server.CreateObject("ADODB.Connection"
DataConn.Open "DSN=HeminiWebDSN"
Set cmdDC = Server.CreateObject("ADODB.Command"
cmdDC.ActiveConnection = DataConn
cmdDC.CommandText = strSQLStatement
cmdDC.CommandType = 1
set rsPasswordFile = Server.CreateObject("ADODB.Recordset"
rsPasswordFile.Open cmdDC, , 0', 1
Thank you for your help in advance!