SSL connection: NaviCat can connect, MyDac cannot!

Zsolt Csillag · Post by **Zsolt Csillag** » Tue 09 Dec 2008 17:13

Hello,

I use MyDac 5.70 with Delphi 2006

In NaviCat I can connect to the remote MySql server using ONLY the checkbox "use SSL".

(I don't need to enter Client Certificate and the other options).

Can I do this with MyDac? (I tried and it doesn't work).

How can NaviCat connect without those informations?

I cannot connect from MyDac in either way: with Direct = true, I got 10061 error.With Direct = false I got 11004 error.

thank you in advance

Dimon · Post by **Dimon** » Thu 11 Dec 2008 12:49

To connect to MySQL server via SSL, you should set the TMyConnection.Options.Protocol property to mpSSL.
For using SSL ssleay32.dll and libeay32.dll files are required.

Zsolt Csillag · Post by **Zsolt Csillag** » Thu 11 Dec 2008 13:03

Hello Dimon,

Of course I set TMyConnection.Options.Protocol property to mpSSL.
(I read the documentation before trying).

As for the SSL ssleay32.dll and libeay32.dll files - I copied them in the system32 directory AND in the directory of the exe file.

But the problem is the same.

Thank you

Dimon · Post by **Dimon** » Thu 11 Dec 2008 14:33

I can not reproduce the problem.
Please make sure that you set the Server and Port properties correctly. The 10061 error arises when making an attempt to connect to an inactive service. Usually this error is related to network problems or firewall settings.