Hmm, that is weird. Actually, I had the same issue (sort of). I was grabbing some data from a MySQL instance on an OS X workstation. I had shared the tables in Access via ODBC. I'd start to update the MySQL DB and get an ODBC error. Usually I'd get about 93 rows done (out of 1000 or so).
You're getting the same issue going from Win32 to Linux via ODBC. I wonder if its a bug with the ODBC driver? What version are you using? Anyone else have this problem? Regards, Adam -----Original Message----- From: Pakó Géza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:22 PM To: Fortuno, Adam Subject: Re: Error: "unable to execute query" instantly. if i execute inserts in loop, about 30 runs well, then comes the error. if i reconnect i can exec the next 30, and so on... ----- Original Message ----- From: "Fortuno, Adam" <[EMAIL PROTECTED]> To: "'Pakó Géza'" <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 8:16 PM Subject: RE: Error: "unable to execute query" Peko, "it breaks in the sec the sentence is..." what do you mean by "sec"? Regards, Adam -----Original Message----- From: Pakó Géza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:06 PM To: Fortuno, Adam Subject: Re: Error: "unable to execute query" no, it breaks in the sec the sentence is executed. and i can reconnect at once thanks! thats fast...:) ----- Original Message ----- From: "Fortuno, Adam" <[EMAIL PROTECTED]> To: "'Pakó Géza'" <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 8:02 PM Subject: RE: Error: "unable to execute query" Did the connection time out? -----Original Message----- From: Pakó Géza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 1:44 PM To: [EMAIL PROTECTED] Subject: Error: "unable to execute query" hello, Im writing a db software using delphi7 & mysql(3.23.41) (with standard dbexpress and data access components) The problem is: sometimes i get the error message "unable to execute query", and the connection breaks. i only saw this occur on UPDATEs or INSERTs, but every time a different line in the code, which otherwise executes ok. If i use an xception handler, reconnect manually and execute the statement again it works fine, but it would be important to know whats causing this. I can invoke this error by executing updates or inserts repeatedly (needs about 30-50 repeated command) but it also happens when i update only 1 field in 1 record. Mysql logs show no error. The connection between the server & clients is throught 10mbps lan, server runs on redhat 7.3, clients on windows machines. unfortunately, this is extremely urgent 4 me, any help would be appreciated... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
