Devart Forums

Hi,
Thanks for the help so far,
i getting annoyed by Socket error on connect. WSAGetLastError return 10060($274C) error all the time,
this is happening on Scrip execute and Query execute and what is interesting is that it happened only in procedure that calling to two MySQL servers one after one.
it happpenning several clients spreading around,
i set the time out to 60 seconds, but it still keep coming.
just must say that when i;'m using different MySQL component , i don;t get any error,
something i'm doing wrong ?

Lior,

and one more thing,
i measured the time it take for the spitting the error, it 11-21 seconds,
the the 60sec timeout i set should be intact ?

Thank you for information. Unfortunately we could not reproduce the problem.
Please send a complete small sample to evgeniyD*crlab*com to demonstrate it, including script to create and fill table(s).

Also supply us the following information
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor

Probably there is something wrong with your network. Please check settings of your proxy, firewall, antivirus software, etc. Does the problem appear if the second server is located on localhost?

Hi,
i thing i manage to fix it by setting the pooling to True.
i wonder why .... ?

i have a new problem now, the MYSQL server is crashing one a day when using SSL, strange ....
any lead ?

Lior,

i thing i manage to fix it by setting the pooling to True.
i wonder why .... ?

It is good to see that this problem has been solved.
Probably the reason of this problem is in your environment. If you set Pooling to True, connection is not actually released. It is put into pool. Then if you try to establish a connection with the same settings, it is just obtained from the pool. So enabling pooling does not solve this problem completely. Probably you will encounter it later in a different form.

i have a new problem now, the MYSQL server is crashing one a day when using SSL, strange ....
any lead ?

Try to enable logging in the server and check log files after the crash. Make sure that you use the last version of MySQL Server. Probably this is a fixed server problem.

What is the latest SSL libs you tested MyDAC ?
i'm using the latest one
and i get all the time
Assertion failure (d:\Projects\Delphi\Mydac\Source\MySqlVioTcpSSL.pas, line 87)
any idea ?
i'm using Delphi 2006 with your latest MyDAC ( not the Beta)

We tested MyDAC with OpenSSL 0.9.7c. We know about problems with latest versions of OpenSSL. Now we are working on supporting the last OpenSSL version. It will be added to the nearest builds of MyDAC 4 and MyDAC 5 beta.

Thank you,
any have any estimation when it will b e ready ?

Lior,

We plan to release the new build of MyDAC 4 in about two or three weeks.

Thank You for your reply.

Lior,