expert69
asked on
Error using insert sql in ASP -Access, NT4.0
I get an operation must use an updatable query error when trying to instert a record into an access(97) database. Server is NT 4.0, IIS, The asp script is listed below:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query.
/findit/signinhandle.asp, line 50
Conn.Open "DBQ=C:\wwwroot\guestbook\ guest.mdb; DefaultDir =c:\wwwroo t\guestboo k;Driver={ Microsoft Access Driver (*.mdb)};DriverId=25;FIL=M S Access;ImplicitCommitSync= Yes;MaxBuf ferSize=51 2;MaxScanR ows=8;Page Timeout=5; SafeTransa ctions=0;T hreads=3;U ID=admin;U serCommitS ync=Yes;"
sql = "INSERT INTO tblGuests(Name, EMail, Address1, Address2, City, State, Zip, Kiss, Rock, CheapTrick, ClassicRock, Alt, refer, Comment, Host_Name) "
sql = sql & "VALUES('" & Request("uName") & "', '" & Request("ueMAIL") & "', '" & Request("uaddress1") & "', '" & Request("uaddress2") & "', '"
sql = sql & Request("uCity") & "', '" & Request("uState") & "', '" & Request("uZip") & "', '" & Request("uKiss") & "', '" & Request("uRock") & "', '" & Request("uCheapTrick") & "', '" & Request("uClassicRock") & "', '" & Request("uAlt") & "', '" & Request("urefer") & "', '" & Request("ucomment") &"', '" & CStr(Request.ServerVariabl es("REMOTE _HOST")) & "')"
Conn.Execute(sql)
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query.
/findit/signinhandle.asp, line 50
Conn.Open "DBQ=C:\wwwroot\guestbook\
sql = "INSERT INTO tblGuests(Name, EMail, Address1, Address2, City, State, Zip, Kiss, Rock, CheapTrick, ClassicRock, Alt, refer, Comment, Host_Name) "
sql = sql & "VALUES('" & Request("uName") & "', '" & Request("ueMAIL") & "', '" & Request("uaddress1") & "', '" & Request("uaddress2") & "', '"
sql = sql & Request("uCity") & "', '" & Request("uState") & "', '" & Request("uZip") & "', '" & Request("uKiss") & "', '" & Request("uRock") & "', '" & Request("uCheapTrick") & "', '" & Request("uClassicRock") & "', '" & Request("uAlt") & "', '" & Request("urefer") & "', '" & Request("ucomment") &"', '" & CStr(Request.ServerVariabl
Conn.Execute(sql)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER