[solved] SSL Connection to MySQL Problem

[zhalcon]

Hi, first of all, thanks for these cool components. I use a Windows XP Service Pack 3 and Delphi 6.

I wonder if you can connect via SSL with Zeos DBO 6.5.1 Alpha and MySQL 5.0.96.

With Zeos 7, I can connect, using the protocol mysql-5 in the dropdown property protocol of component TZConnection. But I have installed this version (Zeos 7) on Delphi 2010, which I can't use, because I need another components, and some of them I have only for Delphi 6.

The problem is that when using Zeos 6.5.1 in Delphi 6, I can only choose mysql-4.1 protocol and using this protocol, I get an access denied error.

Thank you very much for your help.

[Pitfiend]

I recomend you to update to ZeosLib 6.6.6, you will be able to use mysql-5. It's very stable, I use it with delphi from 5 to 2007 without troubles. Also have a look on your delphi installation, it may has an older mysql dll that causes many troubles, just remove or replace it with a newer one.

About SSL, I can't be sure if it's available, never try that.

[zhalcon]

Thanks, Pitfiend, I was thinking it, I'll try it with Zeos 6.6. I'll write here what is the result.


Thanks very much again.

[zhalcon]

Effectively, the error was the version of Zeos. Now, with 6.6.6, it runs ok.

Thanks very much.

[Pitfiend]

You welcome, don't esitate to ask when in troubles. Many in the forums can help you!