da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: bad handshake

Forum List » AnyDAC » v 1.x General English

pek
User

Fresh Boarder

Posts: 6

Karma: 0

bad handshake

Posted: 2007/05/22 02:53

After installation of AnyDAC on the one computer everything was ok, but on the (the same DBMS) second surprise: [AnyDAC][Phys][MySQL][LIBMYSQL] Bad handshake
What is a reason of error?
AnyDAC 1.12.2 + Bbds2006 + MySQL 5.0.37
With best regards.
Richard

Diman

Admin

Posts: 1496

Karma: 19

Re:bad handshake

Posted: 2007/05/22 03:05

Hello

Most probable reason, the libmysql.dll is not of 5.0.37 version and is much more old, than this version. You should find libmysql.dll on "bad" computer and replace it with appropriate one.

Regards,
Dmitry

pek
User

Fresh Boarder

Posts: 6

Karma: 0

Re:bad handshake

Posted: 2007/05/23 01:47

I forgot to say that error has place only in run time. I design time everything is OK, I have connections to database and I see dbgrid with data. MySQL 5.0.37 is installed on my computers.
Sorry for elementary question, do I need libmysql.dll in order to connect to MySQL?
I thanked that AnyDAC has possibility of direct connection to MySQL.
With best regards.
Richard

Diman

Admin

Posts: 1496

Karma: 19

Re:bad handshake

Posted: 2007/05/23 01:51

Sorry for elementary question, do I need libmysql.dll in order to connect to MySQL?
AnyDAC uses libmysql.dll, because it is recomended by vendor - MySQL AG - client connectivity way.

Regards,
Dmitry

pek
User

Fresh Boarder

Posts: 6

Karma: 0

Re:bad handshake

Posted: 2007/05/24 02:09

Thanks, the problem was libmysql.dll.
So, I guess that AnyDAC used to connect to MySQL direct in design time and via libmysql.dll in run time. It suggests my another elementary question: is it possible to connect to MySQL direct in run time without any dll’s?
With best regards.
Richard

Diman

Admin

Posts: 1496

Karma: 19

Re:bad handshake

Posted: 2007/05/24 04:31


 is it possible to connect to MySQL direct in run time without any dll’s?

In design and run times, AnyDAC uses libmysql.dll to connect to MySQL.

Regards,
Dmitry

Forum List » AnyDAC » v 1.x General English