Error #08S01Bad handshake - MySQL 5.5.12,Win64,Delphi7

[petrn]

UniDAC Trial v3.70.0.17 for Delphi7 used.
Error happens in TUniConnection component when I try Connect button.

Any solution?

Many thanks.

[Dimon]

Please try connecting to MySQL server with third-party applications, like EMS SQL Manager or any others. If the problem still exist?

[petrn]

I can connect without any problems with any other application, other 3rd party Delphi DACs, MySQL Workbench.

I could connect to 5.0.18 with previous trial version, then I upated MySQL to 5.5.12 and I could not, I upgraded to the 3.7 and I still can not. I think I could conntect to MySQL 5.5.11 with previous UniDAC.

Does anybody connects to 64bit,Win7, Delphi7, MySQL 5.5.12 successfully?

[Dimon]

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next UniDAC build.

[resm]

Hi,

our application worked fine with unidac vcl 3.5.

Yesterday our server provider updated from MySQL 5.1.51 to 5.1.56.

Now we get the error "bad handshake", tying unidac 3.70.0.17 still same error.

So we are in urgent need of the next build. Please: when can we expect this?

Thanks!

[AndreyZ]

The next UniDAC build will be available in two weeks.

[stevel]

I need MySQL connectivity and this 'bad handshake' thing means that I have stopped my project.

[AndreyZ]

The next UniDAC build will be available in two days. We will post an announcement on the forum about the new build.

[DanielH]

There is still the same error "Bad Handshake" with:

- Embarcadero RAD Studio XE (C++ Builder)
- UniDAC 3.70.0.18 for RAD Studio XE
- MySQL Server 5.5.13


it occurs when I try to connect to the database.

Any solution?

Regards,

[AndreyZ]

Please try the following:
- close RAD Studio XE;
- remove UniDAC;
- remove all *dac*.bpl files from your computer;
- reinstall UniDAC.

[DanielH]

I made the steps,but when I try to compile my project
I get an erorr E2040 (Declaration terminated incorrectly) in CRParser.hpp line 210 -> "static const int BLOCK_SIZE = 0x10000;"

When I edit this line e.g. "static const int _BLOCK_SIZE = 0x10000;",the project can be compiled.Note the "_" before BLOCK_SIZE .

When I start the project,(connect to MySQL DB) the "Bad Handshake" error
still occurs.

Regards,
Daniel

[AndreyZ]

We can connect to your computer using Remote Desktop Connection, and try determining the cause of this problem. Could you please provide us access to your computer? If yes, please send your IP, username, and password to andreyz*devart*com.

[DanielH]

Hello,

A Remote Desktop Connection is not possible in the company network ...
Note: My Project is under Win32

Environment (Win 32):
- Embarcadero RAD Studio XE (C++ Builder)
- UniDAC 3.70.0.18 for RAD Studio XE
- MySQL Server 5.5.14

Regards,

[AndreyZ]

Please try the following:
- remove UniDAC;
- remove all *dac*.bpl, *dac*.bpi, *dac*.dcp, and *dac*.hpp files from your computer;
- reinstall UniDAC.
If it doesn't help, please try the following:
- remove UniDAC;
- run UniDAC installation with the /force parameter like this: unidac370d15pro.exe /force.

[DanielH]

I have found a workaround for the "Bad Handshake" Problem:

- In the used TUniConnection object at options for provider,in my case MySQL, I changed at the key "Direct" the value from "True" to "False".

- After that, the libmysql.dll is needed at the own application (same folder or an folder defined in PATH)

you can find libmysql.dll in installfolder of MySQL Server , subfolder lib

Finally I can connect to MySQL Server with UniDAC