Click here to Skip to main content
14,450,535 members
Rate this:
Please Sign up or sign in to vote.
Web application developed in VS2008 3.5 framework. At first I used Microsoft SQL server but because of some issue i have shifted on to MySQL database and successfully installed the tables also. And the website is also well published using plesk pannel 9.5

The problem now occurred is that no data is getting saved on MySQL tables on plesk pannel. On searching I got this error:

MySql.Data.MySqlClient.MySqlException: Out of sync with server at
MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read) at
MySql.Data.MySqlClient.NativeDriver.AuthenticateNew(Boolean reset) at
MySql.Data.MySqlClient.NativeDriver.Authenticate(Boolean reset) at
MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at
MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at
MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at
MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at
MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at
MySql.Data.MySqlClient.MySqlPool.GetConnection() at
MySql.Data.MySqlClient.MySqlConnection

but in developed machine, it working fine.

Please let me know the issues in it
Posted
Updated 31-May-13 2:57am
v2
Comments
ZurdoDev 31-May-13 7:58am
   
I don't do MySql but it sounds like the version on the server is not compatible with your code.
   
Which version of MySQL are you using ?
Prasad Khandekar 31-May-13 9:37am
   
Please check the server version and driver MySQL Net connector versions first.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100