[Mono-list] MySQL on Mono

[Joe Audette]

Hi,

On 2/5/07, victor.andy at wingscorp.com <victor.andy at wingscorp.com> wrote:

> I have a few questions for you:
> 1. I don't get any MySQL to .NET Connector for .NET  framework 1.0, just get
> for .NET framework 2.0
> (http://dev.mysql.com/downloads/connector/net/5.0.html).
>     if there MySQL .NET Connector for .NET framework 1.0 ?

For 1.1 framework use
http://dev.mysql.com/downloads/connector/net/1.0.html


> 2. i'm creating project  using Visual Studio 2005 (.NET framework 2.0), it
> got error if i'm creating using VB, but if i'm using C# there's no error.
>     Is that mean in Visual Studio 2005, mono is more supported C# than
> VB.NET?

Yes c#is better supported I think. Though maybe others can answer this
better than me.

> 3. I'm creating project using VS2005, connecting to MySQL (because i can't
> find the connector for VS2003) and the project is write in C#.
>     the MySQL database is installed in Windows.

this connector works in VS 2003
http://dev.mysql.com/downloads/connector/net/1.0.html

>     If i'm run the app to connect to MySQL in windows it works fine, but
> when i run the app in Linux it's throw exception like this :
>     Unhandled Exception:
> MySql.Data.MySqlClient.MySqlException: Unable to connect to
> any of the specified MySQL hosts
>     is this exception is because the MySQL database is installed on Windows
> not in Linux, and the app in linux can't find the MySQL on Windows?
>    or i have miss something to do this ??

Most likely cause is if the linux machine can't resolve the host name
of the windows machine. Put the name of the windows machine and its ip
address in the etc/hosts file on linux or try using the ip address of
the windows machine in the connection string

Hope it helps,

Joe