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]