Luis01 de Agosto del 2004
Preguntatengo esta pequeña rutina pra ingresar datos y el servidor me entrega error y ya la he cambiado como mil veces.... a quien me pueda ayudar se lo agradezco!!!
este es el error
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
y esta es la programacion
<%
on error resume next
t = request.form("tit")
d = request.form("des")
f = request.form("fech")
n = request.form("nom")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" + Server.MapPath("not.mdb") + ";uid=;pwd="
'Conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("not.mdb"))
sqlstr= "insert into noticias values('" & t & "','" & d & "','" & f & "','"& n & "')"
Conn.execute(sqlstr)
Conn.Close
set conn = nothing
if err.number <> 0 then
Response.Write "Insercion NO realizada"
Response.Write "<br>" & err.description
else
Response.Write "Insercion realizada con exito"
End if
%>
este es el error
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
y esta es la programacion
<%
on error resume next
t = request.form("tit")
d = request.form("des")
f = request.form("fech")
n = request.form("nom")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" + Server.MapPath("not.mdb") + ";uid=;pwd="
'Conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("not.mdb"))
sqlstr= "insert into noticias values('" & t & "','" & d & "','" & f & "','"& n & "')"
Conn.execute(sqlstr)
Conn.Close
set conn = nothing
if err.number <> 0 then
Response.Write "Insercion NO realizada"
Response.Write "<br>" & err.description
else
Response.Write "Insercion realizada con exito"
End if
%>
