RE: ADO Bulk Inserts

2002-12-11 Thread Paul DuBois
At 1:31 -0500 12/11/02, Michael She wrote: At 11:00 PM 12/10/2002 -0600, Paul DuBois wrote: Yes, a single bulk insert will be faster. Also, the reason your "multiple statements separated by semicolons" approach fails with a syntax error is that the client server protocol does not allow you to se

RE: ADO Bulk Inserts

2002-12-11 Thread Michael She
Actually, no that isn't how I was doing it - I was concatenating multiple inserts together like you do on SQL server. (ie Insert... Insert... Insert...) Thanks for the Insert Sytax! I'll give this a go! At 08:14 AM 12/11/2002 -0500, Anderson, Alan R wrote: > From: Michael She [mailto:[EMAIL PR

RE: ADO Bulk Inserts

2002-12-11 Thread ed
The proper way to do a bulk insert is: INSERT INTO tablename VALUES(field1,field2,field3),(field1,field2,field3),(field1,field2,fie ld3),(field1,field2,field3) etc.. On 11 Dec 2002 at 1:31, Michael She wrote: > At 11:00 PM 12/10/2002 -0600, Paul DuBois wrote: > >Yes, a single bulk insert will

RE: ADO Bulk Inserts

2002-12-11 Thread Anderson, Alan R
> From: Michael She [mailto:[EMAIL PROTECTED]] > ...So are you saying that the Windows ODBC MySQL driver > doesn't support multiple statements? So far as I know, *no* drivers support multiple statements. However, that's not what you want for "bulk inserts". What you want is multiple value sets

RE: ADO Bulk Inserts

2002-12-10 Thread Michael She
At 11:00 PM 12/10/2002 -0600, Paul DuBois wrote: Yes, a single bulk insert will be faster. Also, the reason your "multiple statements separated by semicolons" approach fails with a syntax error is that the client server protocol does not allow you to send multiple statements in the same string.

RE: ADO Bulk Inserts

2002-12-10 Thread Paul DuBois
Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 13:55 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk Inserts Hi, That is how I currently submit my statements, but can't I go: Hi, that is how I execute my current statements. But

RE: ADO Bulk Inserts

2002-12-10 Thread Michael She
loop? Do Until rst.EOF dbConn.Execute("INSERT STATMENT"); Loop JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 13:55 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk Inserts Hi, That is how I

RE: ADO Bulk Inserts

2002-12-10 Thread Fernando Grijalba
lp Subject: RE: ADO Bulk Inserts Hi, That is how I currently submit my statements, but can't I go: Hi, that is how I execute my current statements. But can't I submit multiple statements like: "INSERT INTO tblname(fld1) VALUES(val1);INSERT INTO tblname(fld1) VALUES(val1)

RE: ADO Bulk Inserts

2002-12-10 Thread Michael She
nt: December 10, 2002 12:08 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk Inserts Same table, but it shouldn't matter right? I'm getting a SQL syntax error once I start combining my statements together. If I submit the statements separately they're OK. At 09:59

RE: ADO Bulk Inserts

2002-12-10 Thread Fernando Grijalba
Have you try this: dbConn.Execute("INSERT INTO tblname(fld1, fld2) VALUES(val1, val2),(val1,val2),(val1,vla2);") JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 12:08 To: Fernando Grijalba Cc: MySQL Help Subject: RE

RE: ADO Bulk Inserts

2002-12-10 Thread Michael She
Same table, but it shouldn't matter right? I'm getting a SQL syntax error once I start combining my statements together. If I submit the statements separately they're OK. At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote: Are the inserts to the same table or different tables and columns?

RE: ADO Bulk Inserts

2002-12-10 Thread Fernando Grijalba
Are the inserts to the same table or different tables and columns? JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 14:56 To: MySQL List Subject: ADO Bulk Inserts Hi All, Does MySQL allow for Bulk Inserts via ADO? I can get a