I want to retrieve all tables of a MySqL Datbase. But the following code delivers only an empty DataTable with MySQL 5.1. It works fine with MS SQL.
regards,
chris
Code: Select all
private void GetTableData(Provider prov, string datasource, string database, int port, string userId, string password)
{
Devart.Data.Universal.UniConnection uc = new Devart.Data.Universal.UniConnection();
uc.Provider = prov.ToString().Replace("_", " ");
uc.DataSource = datasource;
uc.Database = database;
uc.UserId = userId;
uc.Password = password;
uc.Open();
this.dtTables = uc.GetSchema("Tables");
uc.Close();
}