[Mono-list] System.Data.SqlClient.SqlException: 'int' is not a recognized CURSOR option

S Umadevi sUmadevi@novell.com
Thu, 14 Oct 2004 22:09:40 -0600


Hello
  Looks like there is a problem with the System.Data.SqlClient code.
Can you please send the stored procedure that is getting executed from
the code?
Also if you can isolate and send only the sqlclient access portion of
the code as a unit testcase it would faster to debug and fix the
problem.

Regards
uma

>>> "Ing. Michal Skala" <michal@orix.sk> 10/14/04 5:50 PM >>>
Hello,

I have attached the full source.

And here is the full error output:

Server error in '/poll' application



Description: Error processing request. 
Error Message: HTTP 500. 
Stack Trace: System.Data.SqlClient.SqlException: 'int' is not a
recognized CURSOR option.
in <0x0011b> System.Data.SqlClient.SqlConnection:ErrorHandler
(object,Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
in <0x00069> (wrapper delegate-invoke)
System.MulticastDelegate:invoke_void_object_TdsInternalErrorMessageEventArgs
(object,Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
in <0x00031> Mono.Data.Tds.Protocol.Tds:OnTdsErrorMessage
(Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
in <0x00056> (wrapper remoting-invoke-with-check)
Mono.Data.Tds.Protocol.Tds:OnTdsErrorMessage
(Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
in <0x00276> Mono.Data.Tds.Protocol.Tds:ProcessMessage
(Mono.Data.Tds.Protocol.TdsPacketSubType)
in <0x00052> (wrapper remoting-invoke-with-check)
Mono.Data.Tds.Protocol.Tds:ProcessMessage
(Mono.Data.Tds.Protocol.TdsPacketSubType)
in <0x0015f> Mono.Data.Tds.Protocol.Tds:ProcessSubPacket ()
in <0x00050> Mono.Data.Tds.Protocol.Tds:NextResult ()
in <0x00089> System.Data.SqlClient.SqlDataReader:NextResult ()
in <0x0005d> (wrapper remoting-invoke-with-check)
System.Data.SqlClient.SqlDataReader:NextResult ()
in <0x00122> System.Data.SqlClient.SqlDataReader:.ctor
(System.Data.SqlClient.SqlCommand)
in <0x00056> (wrapper remoting-invoke-with-check)
System.Data.SqlClient.SqlDataReader:.ctor
(System.Data.SqlClient.SqlCommand)
in <0x000a2> System.Data.SqlClient.SqlCommand:ExecuteReader
(System.Data.CommandBehavior)
in <0x00054> (wrapper remoting-invoke-with-check)
System.Data.SqlClient.SqlCommand:ExecuteReader
(System.Data.CommandBehavior)
in <0x00012>
System.Data.SqlClient.SqlCommand:System.Data.IDbCommand.ExecuteReader
(System.Data.CommandBehavior)
in <0x000be> System.Data.Common.DbDataAdapter:Fill
(System.Data.DataSet,int,int,string,System.Data.IDbCommand,System.Data.CommandBehavior)
in <0x00045> System.Data.Common.DbDataAdapter:Fill
(System.Data.DataSet)
in <0x000f6> Test.App.Auth:Course_Show ()
in <0x00016> ASP.login_aspx:UpdateView ()
in <0x0000e> ASP.login_aspx:Page_Load (object,System.EventArgs)
in <0x00069> (wrapper delegate-invoke)
System.MulticastDelegate:invoke_void_object_EventArgs
(object,System.EventArgs)
in <0x00086> System.Web.UI.Control:OnLoad (System.EventArgs)
in <0x00024> System.Web.UI.Control:LoadRecursive ()
in <0x00198> System.Web.UI.Page:InternalProcessRequest ()
in <0x000c2> System.Web.UI.Page:ProcessRequest
(System.Web.HttpContext)
in <0x002eb> ExecuteHandlerState:Execute ()
in <0x00084> StateMachine:ExecuteState
(System.Web.HttpApplication/IStateHandler,bool&)





Hello,

I have problem with running asp.net page in mono, that connect to
MS-SQL db on windows computer. Mono is installed on linux. This is an
error, that is throwed:
System.Data.SqlClient.SqlException: 'int' is not a recognized CURSOR
option

I have created a small application (one file, only login). This
application is on linux server with mono. This small application uses a
small library, that generated SqlCommand a than runs a stored procedure
on MS-SQL server. The library uses System.Reflection namespace (in
attachment).

When this small application run very well on .NET Framework and IIS on
Windows. But, I don't know, who is the problem in Mono.

Thank's for help me.

Michal


__________ Informacia od NOD32 1.893 (20041013) __________

Tato sprava bola preverena antivirusovym systemom NOD32.
http://www.eset.sk 


Thanks for help me.
Michal