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...
RE: Error: unable to execute query - Problems using Win32 MySQL ODBC driver
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 Gza [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 Gza' [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 Gza [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 Gza' [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 Gza [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]
RE: Error: unable to execute query - Problems using Win32 MySQL ODBC driver
Pako, That blows my theory. Regards, Adam -Original Message- From: Pak Gza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:32 PM To: Fortuno, Adam Subject: Re: Error: unable to execute query - Problems using Win32 MySQL ODBC driver i dont use odbc. i only need libmysql.dll dbexpmysql.dll - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: 'Pak Gza' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:30 PM Subject: RE: Error: unable to execute query - Problems using Win32 MySQL ODBC driver 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 Gza [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 Gza' [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 Gza [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 Gza' [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 Gza [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]