469,609 Members | 1,455 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Microsoft OLE DB Provider for ODBC Drivers

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
Mar 14 '07 #1
2 2760
jhardman
3,406 Expert 2GB
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 .
Expand|Select|Wrap|Line Numbers
  1. for i=0 to (tSim_num)
  2. LINE 47 : 
  3. 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)&"')"
  4.     db_conn.execute(sql)
  5.     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:
Expand|Select|Wrap|Line Numbers
  1. Set objCon = Server.CreateObject("ADODB.Connection")
  2. objCon.Open "Provider=SQLOLEDB;DataSource=wwww;UID=xxx;Pwd=yyy;DataBase=zzzz;"
  3. set objRS = Server.CreateObject("ADODB.Recordset")
  4. objRS.open "SELECT * FROM [Book_files]", objCon, adOpenDynamic, adLockOptimistic
  5.  
  6. for i = 0 to tSim_num
  7.    objRS.addNew
  8.    objRS("projID") = projID
  9.    response.write "projID: " & projID & "<br>" & vbNewLine
  10.    objRS("comment") = null
  11.    response.write "comment: (null)<br>" & vbNewLine
  12.    objRS("carType") = carType(i)
  13.    response.write "carType: " & carType(i) & "<br>" & vbNewLine
  14.    'etc
  15.    objRS.update   
  16. next
  17.  
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
Mar 14 '07 #2
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:
Expand|Select|Wrap|Line Numbers
  1. Set objCon = Server.CreateObject("ADODB.Connection")
  2. objCon.Open "Provider=SQLOLEDB;DataSource=wwww;UID=xxx;Pwd=yyy;DataBase=zzzz;"
  3. set objRS = Server.CreateObject("ADODB.Recordset")
  4. objRS.open "SELECT * FROM [Book_files]", objCon, adOpenDynamic, adLockOptimistic
  5.  
  6. for i = 0 to tSim_num
  7.    objRS.addNew
  8.    objRS("projID") = projID
  9.    response.write "projID: " & projID & "<br>" & vbNewLine
  10.    objRS("comment") = null
  11.    response.write "comment: (null)<br>" & vbNewLine
  12.    objRS("carType") = carType(i)
  13.    response.write "carType: " & carType(i) & "<br>" & vbNewLine
  14.    'etc
  15.    objRS.update   
  16. next
  17.  
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 ....
Mar 15 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Solution2021 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.