Microsoft OLE DB Provider for ODBC Drivers

[phantom3008]

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,'','','','')' at line 1
/save_inc.asp, line 47

I'm getting this error , when i use response.write(sql) instead of db_conn.execute(sql) it works fine .
for i=0 to (tSim_num)
LINE 47 :
sql = "insert into tach values (null,"&projID&",'"&t_carr(i)&"','"&t_carType(i)&" ','"&t_host(i)&"','"&t_dir(i)&"','"&t_pin(i)&"','" &tSim_ip(i)&"',"&t_num(i)&","&t_pc(i)&","&t_UID1(i )&","&t_UID2(i)&",'"&t_by(i)&"','"&t_par(i)&"','"& t_im(i)&"','"&t_auto(i)&"')"
db_conn.execute(sql)
next
Plz help

[jhardman]

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,'','','','')' at line 1
/save_inc.asp, line 47

I'm getting this error , when i use response.write(sql) instead of db_conn.execute(sql) it works fine .

for i=0 to (tSim_num)
LINE 47 : 
sql = "insert into tach values (null,"&projID&",'"&t_carr(i)&"','"&t_carType(i)&"','"&t_host(i)&"','"&t_dir(i)&"','"&t_pin(i)&"','"&tSim_ip(i)&"',"&t_num(i)&","&t_pc(i)&","&t_UID1(i)&","&t_UID2(i)&",'"&t_by(i)&"','"&t_par(i)&"','"&t_im(i)&"','"&t_auto(i)&"')"
    db_conn.execute(sql)
    next

Plz help

It looks like you are passing a whole bunch of empty arguments to the insert line. There is a lot that can go wrong with any sql statement. I would suggest breaking down the insert line into shorter statements like the following. It may not solve the problem, but will likely give you a better idea of where the problem is:

Set objCon = Server.CreateObject("ADODB.Connection")
objCon.Open "Provider=SQLOLEDB;DataSource=wwww;UID=xxx;Pwd=yyy;DataBase=zzzz;"
set objRS = Server.CreateObject("ADODB.Recordset")
objRS.open "SELECT * FROM [Book_files]", objCon, adOpenDynamic, adLockOptimistic
 
for i = 0 to tSim_num
   objRS.addNew
   objRS("projID") = projID
   response.write "projID: " & projID & "<br>" & vbNewLine
   objRS("comment") = null
   response.write "comment: (null)<br>" & vbNewLine
   objRS("carType") = carType(i)
   response.write "carType: " & carType(i) & "<br>" & vbNewLine
   'etc
   objRS.update   
next
 

Like I said before, when you use just one line of code to insert, there is no telling where the problem arose, but this way should let you know where the problem is.

Let me know if this helps.

Jared

[phantom3008]

It looks like you are passing a whole bunch of empty arguments to the insert line. There is a lot that can go wrong with any sql statement. I would suggest breaking down the insert line into shorter statements like the following. It may not solve the problem, but will likely give you a better idea of where the problem is:

Set objCon = Server.CreateObject("ADODB.Connection")
objCon.Open "Provider=SQLOLEDB;DataSource=wwww;UID=xxx;Pwd=yyy;DataBase=zzzz;"
set objRS = Server.CreateObject("ADODB.Recordset")
objRS.open "SELECT * FROM [Book_files]", objCon, adOpenDynamic, adLockOptimistic
 
for i = 0 to tSim_num
   objRS.addNew
   objRS("projID") = projID
   response.write "projID: " & projID & "<br>" & vbNewLine
   objRS("comment") = null
   response.write "comment: (null)<br>" & vbNewLine
   objRS("carType") = carType(i)
   response.write "carType: " & carType(i) & "<br>" & vbNewLine
   'etc
   objRS.update   
next
 

Like I said before, when you use just one line of code to insert, there is no telling where the problem arose, but this way should let you know where the problem is.

Let me know if this helps.

Jared

the prob was in the loop coz it was adding an extra insert ...so instead i did
for i = 0 to (tSim-1) and now it works !! thanks a lot for ur time anyways ....