Bad Handshake error using UniDAC driver

I’m getting “#08S01Bad Handshake” error in Template Wizard when connecting to MySQL using UniDAC driver.

Connection string:
UniDAC?AuxDriver=MySQL;Server=localhost;Database=test;UserID=root;Password=letmein;Port=3306;

Data Abstract version:
RemObjects Data Abstract for Delphi - 6.0.55.957

Hello,
What MySQL version do you use?

I’m using MySQL Server 5.5.14

Hello,
Thanks, the issue was logged as #52874

It was fixed in the latest UniDAC
http://www.devart.com/forums/viewtopic.php?t=20958&start=15&postdays=0&postorder=asc&highlight=

As a workaround you should build Drivers/DAUniDACDrv.dpr project with the latest UniDAC in non-unicode Delphi version and put DAUniDACDrv.dad to DASchemaModeler folder (replace old one).

Hello,

is there any other workaround?
I have the newest UniDac Version unfortunately i have only Delphi XE and XE2 installed,
so it’s for me impossible to rebuild the Driver in non-unicode Delphi.
Rebuilding the driver with XE failed (see attached file)

Any ideas ?

Regards Data

Hello,

is there anybody out there who’s using DataAbstract + UniDAC 4.1.4 + non unicode Delphi Version ?
Please can you rebuild the driver “Drivers/DAUniDACDrv.dpr” and post the “DAUniDACDrv.dad” here ?!

Many thanks in advance,

Regards Data

Hello,
You can use the latest gamma version. This issue was fixed here.
RemObjects Data Abstract for Delphi - 6.0.56.975.exe — Fri, Feb 10, 2012