problem with MySqlClient
Posted by: Ilan Tal
Date: March 14, 2011 07:40AM

Snips out of my program are:
#using "ByteFX.MySqlClient.dll"
using namespace ByteFX::Data::MySqlClient;

m_DbMySqConnection = gcnew MySqlConnection( conn1);
m_DbMySqConnection->Open(); // Open up the connection

where conn1 is like:
Database=harrington;Data Source=10.0.2.2;User Id=fiji;Password=***;
(password has the actual value, not duplicated here.)
I am using Virtualbox on Ubuntu 10.10 to host XP in a Virtualbox, and thus the data source points back to the Ubuntu host.

When it tries to open I get the error message:
Client does not support authentication protocol requested
by server; consider upgrading MySQL client

This is explained in the documentation as:
MySQL 5.5 uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older (pre-4.1) clients.

My question is why ByteFX is so old and how can I upgrade it? Likewise do I have any other choices other than ByteFX? Could I somehow use
#using "MySql.MySqlClient.dll"
using namespace MySql::Data::MySqlClient;

and if so, HOW???

I should mention that I also have a Java program accessing the same MySQL database. The Java program works with no problems, which is one reason I wanted to update the old c++ program.

Thanks,
Ilan

Options: ReplyQuote


Subject
Views
Written By
Posted
problem with MySqlClient
1343
March 14, 2011 07:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.