ADODB error - please help?

Discussion in 'ASP General' started by Mark, Dec 3, 2003.

  1. Mark

    Mark Guest

    Hi - Can anyone please help with the error message below - server is XP
    Pro, and the ASP code it is failing at is (set
    MM_rsUser.ActiveConnection... as below):

    <%
    MM_valUsername=CStr(Request.Form("username"))
    If MM_valUsername <> "" Then
    MM_redirectLoginSuccess="fixit_ebase.asp"
    MM_redirectLoginFailed="fixit_login.asp?failed=yes"
    MM_flag="ADODB.Recordset"
    set MM_rsUser = Server.CreateObject(MM_flag)
    MM_rsUser.ActiveConnection = conFixitCon
    MM_rsUser.Source = "SELECT username, userpassword,
    email,edtick,adfix,apfix,delfix,sendap,amuser,viewcom,viewst,viewrev,vie
    wstats,edstmts,qrydb,efstats,edclient,canview,browsol FROM tblaccess
    WHERE username='" & Replace(MM_valUsername,"'","''") &"' AND
    userpassword='" & Replace(Request.Form("userpassword"),"'","''") & "'"
    ..
    ..


    Please try the following:

    Click the Refresh button, or try again later.

    Open the pc2 home page, and then look for links to the information you
    want.

    HTTP 500.100 - Internal Server Error - ASP error
    Internet Information Services

    ------------------------------------------------------------
    Technical Information (for support personnel)

    Error Type:
    ADODB.Recordset (0x800A0E7A)
    Unknown runtime error
    /sitefiles/login.asp, line 56

    Browser Type:
    Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MyIE2; Alexa Toolbar;
    ..NET CLR 1.1.4322)

    Page:
    POST 46 bytes to /sitefiles/login.asp

    POST Data:
    username=admin&userpassword=admin&Submit=Login

    Time:
    02 December 2003, 19:26:22

    More information:
    Microsoft Support

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Mark, Dec 3, 2003
    #1
    1. Advertising

  2. See http://www.aspfaq.com/2340

    Stop letting wysiwyg editors created such bloated code

    <%
    username = replace(Request.Form("username"), "'", "''")
    password = Request.Form("userpassword"), "'", "''")
    if username <> "" and password <> "" then
    sql = "SELECT COUNT(*) FROM tblaccess " & _
    " WHERE username='" & username & "'" & _
    " AND userpassword='" & password & "'"
    set rs = conFixitCon.execute(sql)
    if not rs.eof then
    response.redirect "fixit_ebase.asp"
    else
    response.redirect "fixit_login.asp?failed=yes"
    end if
    ....
    --
    Aaron Bertrand
    SQL Server MVP
    http://www.aspfaq.com/




    "Mark" <> wrote in message
    news:...
    > Hi - Can anyone please help with the error message below - server is XP
    > Pro, and the ASP code it is failing at is (set
    > MM_rsUser.ActiveConnection... as below):
    >
    > <%
    > MM_valUsername=CStr(Request.Form("username"))
    > If MM_valUsername <> "" Then
    > MM_redirectLoginSuccess="fixit_ebase.asp"
    > MM_redirectLoginFailed="fixit_login.asp?failed=yes"
    > MM_flag="ADODB.Recordset"
    > set MM_rsUser = Server.CreateObject(MM_flag)
    > MM_rsUser.ActiveConnection = conFixitCon
    > MM_rsUser.Source = "SELECT username, userpassword,
    > email,edtick,adfix,apfix,delfix,sendap,amuser,viewcom,viewst,viewrev,vie
    > wstats,edstmts,qrydb,efstats,edclient,canview,browsol FROM tblaccess
    > WHERE username='" & Replace(MM_valUsername,"'","''") &"' AND
    > userpassword='" & Replace(Request.Form("userpassword"),"'","''") & "'"
    > .
    > .
    >
    >
    > Please try the following:
    >
    > Click the Refresh button, or try again later.
    >
    > Open the pc2 home page, and then look for links to the information you
    > want.
    >
    > HTTP 500.100 - Internal Server Error - ASP error
    > Internet Information Services
    >
    > ------------------------------------------------------------
    > Technical Information (for support personnel)
    >
    > Error Type:
    > ADODB.Recordset (0x800A0E7A)
    > Unknown runtime error
    > /sitefiles/login.asp, line 56
    >
    > Browser Type:
    > Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MyIE2; Alexa Toolbar;
    > NET CLR 1.1.4322)
    >
    > Page:
    > POST 46 bytes to /sitefiles/login.asp
    >
    > POST Data:
    > username=admin&userpassword=admin&Submit=Login
    >
    > Time:
    > 02 December 2003, 19:26:22
    >
    > More information:
    > Microsoft Support
    >
    > *** Sent via Developersdex http://www.developersdex.com ***
    > Don't just participate in USENET...get rewarded for it!
    Aaron Bertrand [MVP], Dec 3, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jim Lacenski
    Replies:
    1
    Views:
    2,773
    Natty Gur
    Oct 18, 2003
  2. PJ
    Replies:
    1
    Views:
    1,792
    George Ter-Saakov
    Oct 30, 2003
  3. KK
    Replies:
    2
    Views:
    552
    Big Brian
    Oct 14, 2003
  4. ern edwar
    Replies:
    0
    Views:
    297
    ern edwar
    Nov 15, 2005
  5. Replies:
    6
    Views:
    145
    Bob Barrows [MVP]
    May 29, 2008
Loading...

Share This Page