ansaurus

Question

Error connecting to MySQL Database using .NET.

Answer 1

A:

Check that the ODBC driver is properly installed (run odbcad32.exe and go to the drivers tab)

Anyway, you should use the native ADO.NET provider rather than the ODBC driver, it's more efficient.

Thomas Levesque 2010-08-14 23:07:15

What do I look for in the drivers tab? This is the first time i've ever used MySQL with .net and this was the only way I could get it to work. Can you elaborate on what you mean by "use the native ADO.NET provider rather than the ODBC driver"?

Abe Miessler 2010-08-14 23:11:20

Also, when I say "get it to work" i'm talking about on my hosting environment (godaddy). I'm having the problem on my development environment.

Abe Miessler 2010-08-14 23:12:07

@Abe Miessler Use http://dev.mysql.com/downloads/connector/net/ instead of the ODBC driver.

nos 2010-08-14 23:16:20

what should my connection string look like then? Can I still use a SQLDataSource with that?

Abe Miessler 2010-08-14 23:19:00

@Abe, I mean use the MySQLConnection, MySQLCommand etc classes instead of OdbcConnection, OdbcCommand, etc. And yes, you can still use a SqlDataSource with this provider. You need to specify "MySql.Data.MySqlClient" as the provider name

Thomas Levesque 2010-08-15 00:21:26

I haven't done anything in codebehind so far and i'd like to keep it that way if possible.

Abe Miessler 2010-08-15 01:10:12

You don't need to use any code-behind. You can set the ProviderName directly in the designer

Thomas Levesque 2010-08-15 01:45:43

ansaurus

tags:

views:

answers:

Error connecting to MySQL Database using .NET.

related questions