[Mono-list] MySql 1.1.7 problem also under 1.1.8

[Joe Audette]

Kevin,

My project, mojoportal uses MySQL and I have not had
any problems under mono 1.1.7. In fact my site is
running on that version currently.
http://www.mojoportal.com
The only difference I can see is you are running mono
on windows and mine is running on linux.

I gather that MySQL is running on the same XP machine
and you are running the exact same app with the exact
same connection string in both versions of mono.

If it is a mono bug it must be limited to the windows
version of mono.

Does the app run correctly using the .NET runtime
instead of mono?

Joe

--- Kevin Flanagan <kevin.flanagan at bom.co.uk> wrote:

> I posted a problem recently using MySql with Mono
> 1.1.7 (which is fine under
> Mono 1.1.4). For info, same problem exists under
> Mono 1.1.8. If anyone gets
> a chance to reproduce it (details below) who knows
> MySql and Mono and might
> be able to suggest a workaround, I'd be very
> grateful ... Thanks in advance
> for any help.
> 
> Kevin Flanagan.
> 
> <Original post>
> Environment: Windows XP, MySql 4.1, MySql
> Connecter/NET 1.0.4, Mono 1.1.4
> and 1.1.7
> 
> I recently upgraded a machine from Mono 1.1.4 to
> 1.1.7 and immediately had a
> problem with MySql connections. Now I've put both
> versions on that machine
> and have a two-line test program that does nothing
> more than connect to a
> local MySql database. The test program runs fine
> under 1.1.4 but under 1.1.7
> produces the error: "Unable to connect to any of the
> specified MySQL hosts".
> Since the only difference between the two is the
> version of Mono, I'm
> guessing it must be a Mono problem, but I've not
> been able to find any
> information on it (though there is a thread which
> looks similar here:
>
http://forums.mysql.com/read.php?38,27316,27316#msg-27316
> ). Has anyone
> encountered this problem or found any resolution to
> it? Thanks in advance
> for any info.
> 
> <follow up>
> Yes - no problem. Below is the simple csharp test
> I'm now using (which is ok
> under 1.1.4 but not 1.1.7):
> 
> using System;
> using MySql.Data;
> using MySql.Data.MySqlClient;
> 
> namespace test
> {
> 	/// <summary>
> 	/// Summary description for Class1.
> 	/// </summary>
> 	class Class1
> 	{
> 		/// <summary>
> 		/// The main entry point for the application.
> 		/// </summary>
> 		[STAThread]
> 		static void Main(string[] args)
> 		{
> 			//
> 			// TODO: Add code to start application here
> 			//
> 
> 			MySqlConnection conn;
> 			conn = new MySqlConnection();
> 
> 			conn.ConnectionString = "server=localhost;user
> ID=root;password=test;database=test;pooling=false";
> 			conn.Open();
> 
> 			Console.WriteLine(conn.ServerVersion);
> 			Console.ReadLine();
> 
> 		}
> 	}
> }
> 
> 
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 


joe_audette [at] yahoo dotcom
http://www.joeaudette.com
http://www.mojoportal.com