[Mono-list] ADO.NET status
Marte Castro
cuentas@imarte.net
Thu, 27 Jan 2005 18:47:03 -0600
So could we suggest that ADO.NET is suitable and stable enough for
deployment today? if not, what parts of this proyect are not
recommended to a production environment?
-Marte Castro
mono-list-request@lists.ximian.com wrote:
>Send Mono-list mailing list submissions to
> mono-list@lists.ximian.com
>
>To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.ximian.com/mailman/listinfo/mono-list
>or, via email, send a message with subject or body 'help' to
> mono-list-request@lists.ximian.com
>
>You can reach the person managing the list at
> mono-list-admin@lists.ximian.com
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Mono-list digest..."
>
>
>Today's Topics:
>
> 1. Re: ADO.NET status (George Birbilis)
> 2. Parse error in mod_mono 1.0.5 on SuSE (Bacchus Hraphanidousai)
> 3. Re: ADO.NET status (Atsushi Eno)
> 4. Re: Xcopy deployment of dlls (Jonathan Pryor)
> 5. Re: RETURN_VALUE from SqlClient? (T Sureshkumar)
> 6. RE: Xcopy deployment of dlls (Chris Aitken)
> 7. RE: Xcopy deployment of dlls (Jonathan Stowe)
> 8. RE: Xcopy deployment of dlls (Chris Aitken)
>
>--__--__--
>
>Message: 1
>Reply-To: "George Birbilis" <birbilis@kagi.com>
>From: "George Birbilis" <birbilis@kagi.com>
>To: <mono-list@lists.ximian.com>
>Subject: Re: [Mono-list] ADO.NET status
>Date: Wed, 26 Jan 2005 21:30:14 +0200
>
>Are WebServices supported on mono?
>If so, is there some page comparing .NET and Mono's support for webservices?
>
>-----
>George Birbilis (birbilis@kagi.com)
>MS MVP J# for 2004, 2005
>http://www.kagi.com/birbilis
>--------------
>
>
>--__--__--
>
>Message: 2
>Date: Wed, 26 Jan 2005 14:06:39 -0800 (PST)
>From: Bacchus Hraphanidousai <phlogiston235@yahoo.com>
>To: mono-list@lists.ximian.com
>Subject: [Mono-list] Parse error in mod_mono 1.0.5 on SuSE
>
>I just installed Mono 1.0.5 on a SuSE server from the
>RPMs. The installation seemed to go without any
>errors. When I tried to load the XSP sample pages, I
>got a parser error: "Error message: Only 1 page is
>allowed."
>
>The following line is highlighted in red in the
>ASP.NET error page: <%@ Import Namespace="System.IO"
>%>
>
>Here is the mono section of my httpd.conf:
>
>Alias /demo "/home/bacchus/public_html/test"
>MonoApplications
>"/demo:/home/bacchus/public_html/test"
><Location /demo>
> SetHandler mono
></Location>
>
>Here is the error message in the apache log:
>
>Directory /etc/apache2/mod-mono-applications does not
>exist.
>** Message: : u_strToLower error: U_FILE_ACCESS_ERROR
>** Message: : u_strToLower error: U_FILE_ACCESS_ERROR
>** Message: : u_strToLower error: U_FILE_ACCESS_ERROR
>** Message: : u_strToLower error: U_FILE_ACCESS_ERROR
>** Message: : u_strToUpper error: U_FILE_ACCESS_ERROR
>** Message: : u_strToUpper error: U_FILE_ACCESS_ERROR
>
>I have seen some discussion of libicu being the
>culprit, when these sorts of errors appear, but that
>was for OS X, not SuSE. I installed libicu from the
>following rpm: libicu26-2.6-94. Is this the problem?
>How might I fix it?
>
>Thanks for any help you can provide!
>
>
>
>__________________________________
>Do you Yahoo!?
>The all-new My Yahoo! - What will yours do?
>http://my.yahoo.com
>
>--__--__--
>
>Message: 3
>Date: Thu, 27 Jan 2005 07:09:15 +0900
>From: Atsushi Eno <atsushi@ximian.com>
>To: George Birbilis <birbilis@kagi.com>
>Cc: mono-list@lists.ximian.com
>Subject: Re: [Mono-list] ADO.NET status
>
>Hi,
>
>George Birbilis wrote:
>
>
>>Are WebServices supported on mono?
>>If so, is there some page comparing .NET and Mono's support for
>>webservices?
>>
>>
>
>Yes and yes. One example is:
>http://mono.ximian.com/class-status/mono-HEAD-vs-fx-1-1/class-status-System.Web.Services.html
>
>Atsushi Eno
>
>--__--__--
>
>Message: 4
>Subject: Re: [Mono-list] Xcopy deployment of dlls
>From: Jonathan Pryor <jonpryor@vt.edu>
>To: Chris Aitken <chris@ion-dreams.com>
>Cc: mono-list@lists.ximian.com
>Date: Wed, 26 Jan 2005 18:15:38 -0500
>
>On Wed, 2005-01-26 at 16:00 +0000, Chris Aitken wrote:
>
>
>>Hi Guys (& gals),
>>
>>Is mono supposed to support xcopy deployment?
>>
>>
>
>Yes.
>
>
>
>>I have to restart xsp (actually apache2 with mod_mono) everytime I add a new
>>dll to my ./bin/ directory.
>>
>>
>
>That's not XCOPY Deployment, at least as I understand it.
>
>XCOPY deployment is the ability to run an application *without* running
>an installer first. Thus the application is location-independent, and
>deploying (installing) to another machine is as simple as copying the
>application.
>
>Which is basically what Mac OS X Application Bundles allow... :-)
>
>What you want is the ability for xsp to restart the AppDomain whenever
>it notices that a DLL has changed within the bin directory. Last I
>knew, this wasn't entirely functional as the FileSystemWatcher wasn't
>entirely functional.
>
> - Jon
>
>
>
>--__--__--
>
>Message: 5
>Date: Thu, 27 Jan 2005 02:13:04 -0700
>From: "T Sureshkumar" <tsureshkumar@novell.com>
>To: <andypalmer@adelphia.net>, <mono-list@lists.ximian.com>
>Subject: Re: [Mono-list] RETURN_VALUE from SqlClient?
>
>Use @RETURN_VALUE instead of RETURN_VALUE as parameter name. This is
>because of the way calling stored procedures is implemented in mono.
>
>suresh.
>
>
>
>>>>Andy <andypalmer@adelphia.net> 1/21/2005 9:30:45 AM >>>
>>>>
>>>>
>Hi,
> I am trying to get a return value from a SQL 7.0 stored procedure.
>
>I am thinking TDS perhaps the protocol wrong? But I do not know how to
>
>set it under mono.
>
>The exception I receive is:
>
>'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 <0x0001e> 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 <0x0017d> TestReturnValue.Program:Main (string[])
>
>Here is some code to reproduce this. I have tried ExecuteNonQuery
>without the DataReader = and with it. Any help would be greatly
>appreciated.
>
>A simple stored proc:
>
>CREATE PROCEDURE sp_ReturnValue @inVal int
>AS
>BEGIN
> return(@inVal)
>END
>
>
>static void Main(string[] args)
>{
> System.Data.SqlClient.SqlConnection conn=null;
> try
> {
> String connstr = PUT SOMETHING HERE;
> conn=new System.Data.SqlClient.SqlConnection(connstr);
> conn.Open();
> System.Data.SqlClient.SqlCommand cmd=
> new System.Data.SqlClient.SqlCommand();
> cmd.CommandText = "sp_ReturnValue";
> cmd.CommandType = System.Data.CommandType.StoredProcedure;
> cmd.Connection = conn;
> SqlParameter parm=
> cmd.Parameters.Add("@inVal",System.Data.SqlDbType.Int);
> parm.Value = 2;
> parm = cmd.Parameters.Add("RETURN_VALUE",
> System.Data.SqlDbType.Int);
> parm.Direction = System.Data.ParameterDirection.ReturnValue;
>
> System.Data.SqlClient.SqlDataReader rs =
> cmd.ExecuteReader();
> int x = cmd.ExecuteNonQuery();
> System.Int32 x =
> (System.Int32)cmd.Parameters["RETURN_VALUE"].Value;
> Console.WriteLine(x);
> rs.Close();
> cmd.Parameters.Clear();
> conn.Close();
> }
> catch(Exception e)
> {
> Console.WriteLine(e.StackTrace);
> Console.WriteLine(e.Message);
> }
> finally
> {
> try { conn.Close(); } catch(Exception e){};
> }
>}
>
>andy
>
>
>
>