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=
