ODBC üzerinden MySQL bağlantı



OdbcConnection Database = new OdbcConnection("Provider=MSDASQL.1;FILEDSN=" + @"C:\blabla\file.dsn");
Database.Open();

OdbcCommand cmdSelect = new OdbcCommand("SELECT * FROM aTable", Database);

OdbcDataReader rsRecords = cmdSelect.ExecuteReader();

while(rsRecords.Read()) {
Console.WriteLine(rsRecords.GetInt32(0));
}
rsRecords.Close();

Database.Close();


file.dsn

[ODBC]
DRIVER=MySQL ODBC 3.51 Driver
UID=zosa
STMT=
OPTION=
PORT=
PASSWORD=xxxxxxxx
SERVER=localhost
DATABASE=zosa
DESC=