I am currently trying to connect and retrieve data from a MySQL database running on my Linux box. Actually I have already succeeded in doing that, however the technologies used does not seem to be the same.

On Windows I used some namespace called MySql.Data.MySqlClient, but on Linux I used ByteFX.Data.MySqlClient. Both of these work on their respective systems, but I would like my project to be independant of where it is compiled, so this is not good enough.

Naturally I have looked at the MySQL site and found the MyODBC driver, which I can get to work on Windows, but not on Linux. The namespace I have included in the project is System.Data.Odbc.

Is this correct? How can I make it work on both machines?

Thanks, Jacob.

__________________
Danish audio books for download at http://www.lytenbog.dk (Danske lydbøger til download).

Alright, I finally figured it out and others might have an interest in this aswell, so here it goes...

I am now using the ODBC driver found at the MySQL site. When using this driver one has to include the namespace System.Data.Odbc, which I originally tried on both systems, however I didn't work to start with. The reason for this was the /etc/mono/config file on Linux. In this file I found the following line... ...which was wrong. When I removed the extesion from the filename it finally worked! Change the filename and you are able to make the ODBC driver work on both systems.

During my research I came across an article which might be interesting for some if you are looking into these things. A link to the article is here...

http://dev.mysql.com/tech-resources/articles/dotnet/

Furthermore I have experienced some differences with the ODBC driver on the two platforms mentioned. Working with the ODBC connection on Linux is much more sensible; e.g. one has to be very exact to specify which datatype you will be retrieving (GetInt16 for SMALLINT, etc.), and also closing connections etc. are more sensible.

Off for now, hope it helps others :)

Jacob.