mardi 5 mai 2015

MySql: Variable 'sql_select_limit' can't be set to the value of '-1'

Hi Guys, I have implemented MySqlSessionStateProvider in asp.net and it works like a charm on my Local PC i.e. Windows 7 but when the application is deployed on Windows Server 2003 on IIS 6.0 it results in the below Exception:

(MySqlException (0x80004005): Variable 'sql_select_limit' can't be set to the value of '-1']
 MySql.Data.MySqlClient.MySqlStream.OpenPacket() +236
 MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows,  Int64& lastInsertId) +60
 MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +50
 MySql.Data.MySqlClient.MySqlDataReader.NextResult() +733
 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +942
 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() +43
 MySql.Data.MySqlClient.MySqlCommand.Close() +67
 MySql.Data.MySqlClient.MySqlDataReader.Close() +77

Can you please advice for the solution as soon as possible. Thanks in advance

Aucun commentaire:

Enregistrer un commentaire