c# - How can I configure the MYSQL ODBC driver to work with Visual Studio 2013? -

c# - How can I configure the MYSQL ODBC driver to work with Visual Studio 2013? -

i've installed mysql server, running local on 127.0.0.1 (i've tried mysql server @ public ip same results).

here how i'm configuring it:

using mysql connector / odbc (running localhost mysql server) using visual studio 2013 c#

i click design tab of webform.aspx page - , click , drag (from toolbox->data->gridview maincontent frame, , drop.

i click [>] button under take info source, take create new info source.

under info source configuration wizard, take sql database.

next pops window, configure info source - sqldatasource1

i click new connection

microsoft odbc info source (odbc) selected info source - leave (note: here, have tried changing mysql info source - connection fails). utilize odbc option.

i click () utilize connection string: , click [build]

a window pops up, , select machine info source tab

i have created info source named test_localhost_mysql, select it.

a window mysql connector/odbc connection parameters appears, of connection data. click test.

success.

i click [ok]

now, add together connection - utilize connection string, filled in, along login information.

i click test connection

success.

i click [ok]

configuration wizard complete, , shows string.

i click [next]

i click [next] without changing anything

now when becomes interesting. on screen;

under specify columns table or view - tables in drop downwards list. periodically, columns show here well. aren't -- i'm sure not random, although i'm not sure i'm doing cause it.

i click [next] after selecting table.

i click [test]

it fails.

i sure it's simple, promise i've been through can think of, , can utilize help please.

anyone can guide me appreciate it.

i anxiously await genious :) give thanks you!

check out. seek install instructions here. study if issue persists. http://www.w3resource.com/mysql/mysql-odbc-connection.php

edit: might want run through of sql code. says sql syntax not correct.

c# mysql asp.net visual-studio-2013