Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Asp Trouble

Options
  • 11-02-2004 2:38pm
    #1
    mada999
    Registered Users Posts: 7,097 ✭✭✭


    Hey all I've got a problem. I have a register asp page and it's not working. I haven't a clue why. It's being working b4 !

    This is the code!


    <%
    'Declare all local variables
    dim conn
    dim rs
    dim strconn
    dim strsql


    strsql = ""
    'set connection string to local variable-I use a DSN-less connection
    strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("users.mdb")

    'build the sql statement based on the input from the form
    strsql="INSERT INTO tableusers (Firstname, Surname, Age, Address1, Address2, Town, County1, Email, Username, Password) "
    strsql=strsql & "Values('" &request("Firstname") & "' , '" &request("Surname") & "' , '" &request("Age") & "', '" &request("Address1") & "' , '" &request("Address2") & "','" &request("Town") & "' , '" &request("County1") & "', '" &request("Email") & "', '" &request("Username") & "', '" &request("Password") & "')"




    'Set connection object
    set conn = server.createobject("adodb.connection")
    conn.open strconn
    'Use the execute method of the connection object the insert the record
    conn.execute(strSQL)
    conn.close
    set conn = nothing
    %>


    <%
    Name=request.querystring("Name")
    response.cookies("name")=Name
    usrname=request.cookies("name")


    Session("UserAutorised") = True
    %>

    <html><head>
    <title>Thanks for registering !</title>
    </head>

    <body link="black" alink="red" vlink="navy"><center>
    <table border="0" width="73%" bgcolor="#ffffff">
    <tr><tr><tr><tr><tr>
    <td width="50%" bgcolor="#ffffff">
    <font face="verdana" size="2" color="#navy"><br><center><br><br><p><P>
    <br><p><p>Thank You For Registering your details here at madaFM ! <br><p>
    Click <a href="login.html">here</a> to Login!

    <br><p><br><p>
    </font>
    </td>
    </table>

    </html>
    End of Code
    (the html form is on another page!)


    The error msg I get is :

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
    /login/register.asp, line 25



    I'm using IIS and MS ACCESS!

    Thanks in advance !

    mada!


Comments

Advertisement