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

Ing. Michal Skala michal@orix.sk
Thu, 14 Oct 2004 15:34:55 +0200
Previous message: [Mono-list] Problem with xml.Serialization
Next message: FW: [Mono-list] Linux version of DPAPI to encrypt Web.config data?
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
This is a multi-part message in MIME format.

--=====003_Dragon751580220505_=====
Content-Type: text/plain;
	charset="windows-1250"
Content-Transfer-Encoding: 7bit

Hello :),

it look's so, that the System.Reflection namespace is no good. When I make my own method to call a stored procedure, everything is OK. Even by use of input and ouput parameter it's ok.

So, thanks, if you can found one another solution ;)

Michal

PS: In the src.zip file, the test_db.cs file. I have forgot one } at end ;) Only for caution.


======== At 2004-10-14, 14:20:23 you wrote: ========

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



__________ Informacia od NOD32 1.894 (20041014) __________

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


= = = = = = = = = = = = = = = = = = = = = =

--=====003_Dragon751580220505_=====
Content-Type: text/html;
	charset="windows-1250"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1250">
<META content="MSHTML 6.00.2900.2523" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff><FONT face=Tahoma size=2></FONT>
<DIV>
<DIV>
<DIV>
<DIV><FONT face=Tahoma size=2>Hello :),</FONT></DIV>
<DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Tahoma size=2>it look's so, that the System.Reflection namespace 
is no good. When I make my own method to call a stored procedure, everything is 
OK. Even by use of input and ouput parameter it's ok.</FONT></DIV>
<DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Tahoma size=2>So, thanks, if you can found one another solution 
;)</FONT></DIV>
<DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Tahoma size=2>Michal</FONT></DIV>
<DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Tahoma size=2>PS: In the src.zip file, the test_db.cs file. I 
have forgot one } at end ;) Only for caution.</FONT></DIV>
<DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV></DIV></DIV></DIV>
<DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Tahoma size=2>======== 
At&nbsp;2004-10-14,&nbsp;14:20:23&nbsp;you wrote: ========</FONT></DIV>
<DIV><BR><FONT face=Tahoma size=2>
<TABLE width="100%">
  <TBODY>
  <TR>
    <TD width="100%">
      <BLOCKQUOTE 
      style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
        <DIV><FONT face=Tahoma size=2>Hello,</FONT></DIV>
        <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
        <DIV><FONT face=Tahoma size=2>I have attached the full 
        source.</FONT></DIV>
        <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
        <DIV><FONT face=Tahoma size=2>And here is the full error 
        output:</FONT></DIV>
        <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
        <DIV>
        <H1><FONT color=red>Server error in '/poll' application</FONT></H1>
        <HR>

        <H2><FONT color=maroon><I></I></FONT></H2><B>Description: </B>Error 
        processing request. 
        <P><B>Error Message: </B>HTTP 500. 
        <P><B>Stack Trace: </B>
        <TABLE width="100%" bgColor=#ffffc summary="Stack Trace">
          <TBODY>
          <TR>
            <TD><CODE><PRE>System.Data.SqlClient.SqlException: 'int' is not a recognized CURSOR option.
in &lt;0x0011b&gt; System.Data.SqlClient.SqlConnection:ErrorHandler (object,Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
in &lt;0x00069&gt; (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_TdsInternalErrorMessageEventArgs (object,Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
in &lt;0x00031&gt; Mono.Data.Tds.Protocol.Tds:OnTdsErrorMessage (Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
in &lt;0x00056&gt; (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.Tds:OnTdsErrorMessage (Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
in &lt;0x00276&gt; Mono.Data.Tds.Protocol.Tds:ProcessMessage (Mono.Data.Tds.Protocol.TdsPacketSubType)
in &lt;0x00052&gt; (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.Tds:ProcessMessage (Mono.Data.Tds.Protocol.TdsPacketSubType)
in &lt;0x0015f&gt; Mono.Data.Tds.Protocol.Tds:ProcessSubPacket ()
in &lt;0x00050&gt; Mono.Data.Tds.Protocol.Tds:NextResult ()
in &lt;0x00089&gt; System.Data.SqlClient.SqlDataReader:NextResult ()
in &lt;0x0005d&gt; (wrapper remoting-invoke-with-check) System.Data.SqlClient.SqlDataReader:NextResult ()
in &lt;0x00122&gt; System.Data.SqlClient.SqlDataReader:.ctor (System.Data.SqlClient.SqlCommand)
in &lt;0x00056&gt; (wrapper remoting-invoke-with-check) System.Data.SqlClient.SqlDataReader:.ctor (System.Data.SqlClient.SqlCommand)
in &lt;0x000a2&gt; System.Data.SqlClient.SqlCommand:ExecuteReader (System.Data.CommandBehavior)
in &lt;0x00054&gt; (wrapper remoting-invoke-with-check) System.Data.SqlClient.SqlCommand:ExecuteReader (System.Data.CommandBehavior)
in &lt;0x00012&gt; System.Data.SqlClient.SqlCommand:System.Data.IDbCommand.ExecuteReader (System.Data.CommandBehavior)
in &lt;0x000be&gt; System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet,int,int,string,System.Data.IDbCommand,System.Data.CommandBehavior)
in &lt;0x00045&gt; System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet)
in &lt;0x000f6&gt; Test.App.Auth:Course_Show ()
in &lt;0x00016&gt; ASP.login_aspx:UpdateView ()
in &lt;0x0000e&gt; ASP.login_aspx:Page_Load (object,System.EventArgs)
in &lt;0x00069&gt; (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs)
in &lt;0x00086&gt; System.Web.UI.Control:OnLoad (System.EventArgs)
in &lt;0x00024&gt; System.Web.UI.Control:LoadRecursive ()
in &lt;0x00198&gt; System.Web.UI.Page:InternalProcessRequest ()
in &lt;0x000c2&gt; System.Web.UI.Page:ProcessRequest (System.Web.HttpContext)
in &lt;0x002eb&gt; ExecuteHandlerState:Execute ()
in &lt;0x00084&gt; StateMachine:ExecuteState (System.Web.HttpApplication/IStateHandler,bool&amp;)</PRE></CODE></TD></TR></TBODY></TABLE></P></DIV>
        <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
        <DIV>&nbsp;</DIV>
        <DIV><BR><FONT face=Tahoma size=2>
        <TABLE width="100%">
          <TBODY>
          <TR>
            <TD width="100%">
              <BLOCKQUOTE 
              style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
                <DIV><FONT face=t></FONT><FONT face=Tahoma 
                size=2>Hello,</FONT></DIV>
                <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
                <DIV><FONT face=Tahoma size=2>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:</FONT></DIV>
                <DIV><FONT face=Tahoma 
                size=2><STRONG>System.Data.SqlClient.SqlException: 'int' is not 
                a recognized CURSOR option</STRONG></FONT></DIV>
                <DIV><STRONG><FONT face=Tahoma 
                size=2></FONT></STRONG>&nbsp;</DIV>
                <DIV><FONT face=Tahoma size=2>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).</FONT></DIV>
                <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
                <DIV><FONT face=Tahoma size=2>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.</FONT></DIV>
                <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
                <DIV><FONT face=Tahoma size=2>Thank's for help me.</FONT></DIV>
                <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
                <DIV><FONT face=Tahoma 
                size=2>Michal</FONT></DIV><BR><BR>__________ Informacia od NOD32 
                1.893 (20041013) __________<BR><BR>Tato sprava bola preverena 
                antivirusovym systemom NOD32.<BR><A 
                href="http://www.eset.sk">http://www.eset.sk</A><BR></BLOCKQUOTE></TD></TR></TBODY></TABLE></FONT></DIV>
        <DIV>
        <P><FONT face=Tahoma size=2>Thanks for help me.</FONT></P>
        <P><FONT face=Tahoma size=2>Michal</FONT></P>
        <P><FONT face=Tahoma size=2></FONT>&nbsp;</P></DIV><BR><BR>__________ 
        Informacia od NOD32 1.894 (20041014) __________<BR><BR>Tato sprava bola 
        preverena antivirusovym systemom NOD32.<BR><A 
        href="http://www.eset.sk">http://www.eset.sk</A><BR></BLOCKQUOTE></TD></TR></TBODY></TABLE></FONT></DIV>
<DIV>
<P><FONT face=Tahoma size=2>= = = = = = = = = = = = = = = = = = = = = 
=</FONT></P></DIV></BODY></HTML>

--=====003_Dragon751580220505_=====--
Previous message: [Mono-list] Problem with xml.Serialization
Next message: FW: [Mono-list] Linux version of DPAPI to encrypt Web.config data?
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]