Hi, Check the rights for your database (trucking.mdb) and database folder (IUSR). Miguel
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ehtisham Sent: Friday, August 12, 2005 6:15 PM To: [email protected] Subject: [ASP] Again Error Please Help Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /vend.asp, line 20 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Page: POST 124 bytes to /vend.asp POST Data: vennam=vend&venaddr=addr&mzipcode=zip&mcity=city&mstat=stat&mcompnam=comp&mp honno=phon&mfaxno=fax&mratreq=rate&mcontnam=main Time: Friday, August 12, 2005, 1:09:15 PM ------------------------- <% @ Language=VBScript %> <% 'Option explicit mvennam= request.form("vennam") mvenadd= request.form("venaddr") mnam1="Ehti" Dim rs, conn, connect, strSQL set conn=server.CreateObject ("adodb.connection") connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("trucking.mdb") & ";Persist Security Info=False" conn.Open connect set rs=Server.CreateObject("adodb.recordset") strSQL = "insert into vend values('" & mnam1 & "')" 'rs.Open strSQL, conn Conn.execute strSQL 'rs.Open strSQL, conn, adOpenKeyset, adLockOptimistic, adCmdText 'response.write(mvennam) 'response.write("<br>") 'response.write(mvenadd) 'Do while not rs.EOF ' response.write rs("name") ' rs.movenext 'loop %> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- SPONSORED LINKS Active <http://groups.yahoo.com/gads?t=ms&k=Active+server+pages&w1=Active+server+pa ges&c=1&s=25&.sig=RaKGWdjhVVcCc4KSxQm4eg> server pages _____ YAHOO! GROUPS LINKS * Visit your group "active-server-pages <http://groups.yahoo.com/group/active-server-pages> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . _____ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hg8r4ol/M=362335.6886445.7839731.1510227/D=groups/S=1705115381:TM/Y=YAHOO/EXP=1123884861/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
