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