Hi,
I used to work with dbexpmda.dll, I used version 2.60(windows) and 3.20(linux).
My programs are written in Delphi 7.
Recently, i've tried to use news versions of this library for windows :
+ 4.20.8 (Bought)
+ 4.7.0.26 (demo)
I encountered a problem with those two versions on Starting Transactions, on my database wich is : Mysql 3.23.53-max-nt
+ with 4.2 : I obtain : EDatabaseError : You have an error in your SQL syntax near '; BEGIN' at line 1
+ with 4.7 : I obtain : EDatabaseError : You have an error in your SQL syntax near '; ' at line 1
Please, have you an idea to solve this problem ?
Regards
Starting Transactions with new version of dbexpmda
You're Welcome.
I encounter another problem with one of my applications which is a multi threaded server.(each thread have his own connection)
At launch, this one makes some requests that cleaning database, that can be long.
On a server 2003, using Mysql 5.0.17 with version 2.60 of dbexpmda, I get the following message:
- SQL Server Error: Lost connection to MySQL server query During
Socket error read it. WSAGetLastError return 10060 ($ 274C)
After searching I saw that version 3.00 of the dll fix a problem like this: (Fixed bug with "Lost connection" on time-consumig executing queries)
So I set up version 3.2 (that we already use on Linux server), which fixes the problem well.
But now I get errors like this after a time of execution :
EOleException; SQL Server Error:
ReceiveHeader: Net packets out of order: Received [110], Expected [1]
Then causing errors:
EDatabaseError; SQL Server Error: Can not connect to MySQL server on 'localhost' (10061)
So I preferred to get back and reinstall version 2.6.0
My questions : is this problem linked to dbxepmda ?
Is this problem known?
If yes which version fixed it?
(My previous post is the result of my search for a version that would correct this problem).
Thanks.
I encounter another problem with one of my applications which is a multi threaded server.(each thread have his own connection)
At launch, this one makes some requests that cleaning database, that can be long.
On a server 2003, using Mysql 5.0.17 with version 2.60 of dbexpmda, I get the following message:
- SQL Server Error: Lost connection to MySQL server query During
Socket error read it. WSAGetLastError return 10060 ($ 274C)
After searching I saw that version 3.00 of the dll fix a problem like this: (Fixed bug with "Lost connection" on time-consumig executing queries)
So I set up version 3.2 (that we already use on Linux server), which fixes the problem well.
But now I get errors like this after a time of execution :
EOleException; SQL Server Error:
ReceiveHeader: Net packets out of order: Received [110], Expected [1]
Then causing errors:
EDatabaseError; SQL Server Error: Can not connect to MySQL server on 'localhost' (10061)
So I preferred to get back and reinstall version 2.6.0
My questions : is this problem linked to dbxepmda ?
Is this problem known?
If yes which version fixed it?
(My previous post is the result of my search for a version that would correct this problem).
Thanks.