Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: bad handshake
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
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
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
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
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
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