Este es otro error
Publicado por KAZANOVA (4 intervenciones) el 17/11/2004 23:51:41
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
set Conn2 = server.CreateObject("ADODB.Connection")
set RS2 = server.CreateObject("ADODB.Command")
Conn2.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("clasificados.mdb"))
Set RS2.ActiveConnection =Conn2
Insertar = "INSERT INTO"& categorias &"(TextoCalsificados, Usuario, Email, FechaPub) VALUES ('"& texto &"','"& usuario &"','"& emai &"','"& fechapublicacion &"')"
Conn2.execute (insertar)
RS2.CommandText = insertar
RS2.Execute
RS2.Close
set RS2 = Nothing
Conn2.Close
set Conn2 = Nothing
RS2.MoveNext
ojala y me puedan hechar la mano
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
set Conn2 = server.CreateObject("ADODB.Connection")
set RS2 = server.CreateObject("ADODB.Command")
Conn2.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("clasificados.mdb"))
Set RS2.ActiveConnection =Conn2
Insertar = "INSERT INTO"& categorias &"(TextoCalsificados, Usuario, Email, FechaPub) VALUES ('"& texto &"','"& usuario &"','"& emai &"','"& fechapublicacion &"')"
Conn2.execute (insertar)
RS2.CommandText = insertar
RS2.Execute
RS2.Close
set RS2 = Nothing
Conn2.Close
set Conn2 = Nothing
RS2.MoveNext
ojala y me puedan hechar la mano
Valora esta pregunta
0