[Mono-list] MySql 1.1.7 problem also under 1.1.8

[Kevin Flanagan]

Hello Martin - I have now tried the ByteFX driver (thanks for the
suggestion), but it gives me a different error: "Client does not support
authentication protocol requested by server; consider upgrading MySQL
client". Given that it all runs ok with Mono 1.1.4 (or the MS .NET runtime),
I think that must be a red herring. Thanks for the input though.

Kevin.

-----Mensaje original-----
De: mono-list-bounces at lists.ximian.com
[mailto:mono-list-bounces at lists.ximian.com]En nombre de Martin Hinks
Enviado el: 20 June 2005 16:05
Para: Kevin Flanagan
CC: mono-list at lists.ximian.com
Asunto: Re: [Mono-list] MySql 1.1.7 problem also under 1.1.8


Hmmm, seems to be a problem with Mono although I haven't tried to
reproduced (yet)...

http://www.mono-project.com/MySQL

Try using the ByteFX (which isnt supported any longer but should work)
as detailed on that page... might be some more info about your problem
there...

Sorry, but this isn't my field of expertise but no-one else answered
your previous query so thought id try and help.

Martin

On 6/20/05, 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
>


--
Martin Hinks
_______________________________________________
Mono-list maillist  -  Mono-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list