The Code, which dropped: dim objConn dim objTimes dim strQuery Set objConn = Server.Createobject("ADODB.Connection") Set objTimes = Server.Createobject("ADODB.Recordset") objConn.Open "HIERONTA" strQuery="INSERT INTO Contacts (Number) VALUES ('15')" set objTimes = objConn.Execute (strQuery)
J
Jarmo
@Jarmo
Posts
-
INSERT INTO/ASP/ADO- error -
INSERT INTO/ASP/ADO- errorThe Code, which dropped: dim objConn dim objTimes dim strQuery Set objConn = Server.Createobject("ADODB.Connection") Set objTimes = Server.Createobject("ADODB.Recordset") objConn.Open "HIERONTA" strQuery="INSERT INTO Contacts (Number) VALUES ('15')" set objTimes = objConn.Execute (strQuery)
-
INSERT INTO/ASP/ADO- errorCan anybody help me? The very simple below code doesnt work. It returns a following error: "Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. "MYDATABASE" is a access database. And "number" is a integer. THANK YOU, JARMO The code: <% dim objConn dim objTimes dim strQuery Set objConn = Server.Createobject("ADODB.Connection") Set objTimes = Server.Createobject("ADODB.Recordset") objConn.Open "MYDATABASE" strQuery="INSERT INTO Contacts (Number) VALUES (15)" set objTimes = objConn.Execute (strQuery)%>
-
INSERT INTO/ASP/ADO- errorCan anybody help me? The very simple below code doesnt work. It returns a following error: "Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. "MYDATABASE" is a access database. And "number" is a integer. THANK YOU, JARMO The code: <% dim objConn dim objTimes dim strQuery Set objConn = Server.Createobject("ADODB.Connection") Set objTimes = Server.Createobject("ADODB.Recordset") objConn.Open "MYDATABASE" strQuery="INSERT INTO Contacts (Number) VALUES (15)" set objTimes = objConn.Execute (strQuery)%>