Hi,

I have build one application which uses static reference of MySQL 4.0 old version library and dynamic reference of new version as MySQL 5.1 version library.
On Solaris
When I try to connect to MySQL server 5.1 using MySQL 5.1 library in application it always uses the old version library instead 5.1 library and I get the following error:

DataAccess: MySQL error: Client does not support authentication protocol requested by server; consider upgrading MySQL client; errno = 1251

On solaris 10 mahcine I have only installed MySQL 5.1. When I try to connect to MySQL server using mysql prompt it connects properly.

Also I have written one sample application which only uses the MySQL 5.1 library dynamic reference and trying to connect to Server 5.1. it connects successfully.

I wonder why in my Application it uses the old even I given or linked the new 5.1 version library.

Is there any compile time linking problem on Solaris or run time problem which does not allows like this mechanism or other else need to do to solve it?

Any help on this highly appreciated?

when I use "mysqlclient.lib" (mysql 5.1.34) on windows in my code and trying to compile the code it gives error as:
mysqlclient.lib(trees.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(inftrees.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(aes.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(random.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(asn.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(md2.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(ctype-tis620.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(integer.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(misc.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(des.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(mf_loadpath.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(xml.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(ctype-ucs2.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(mf_qsort.obj) : error LNK2001: unresolved external symbol ___security_cookie
mysqlclient.lib(yassl_imp.obj) : error LNK2001: unresolved external symbol ___security_cookie

when I include "libmysql.lib" it is compile successfully. But for linking I need to have MySQL 5.1.34 version installed on machine to remote access of MySQL server or need to copy 'libmysql.dll".

I don't want to use libmysql.lib as I don't have to install or copy "dll".

So Is there any way to use "mysqlclient.lib" successfully.