Ok,

I was able to get all the records from the ARTranswCust__ar92a100 table by using the following code...
The Wizard does not seam to be compatible with the Adagio Data Source for some reason. Could be a problem similar to the Excel Query, where it won't display tables with more than 255 columns...

My Data Table was filled after a good 15-20 seconds (it wasn't very fast).
I'll try other tables as well as filter the results to see if I can speedup the process.



DataTable vendorTransactions = new DataTable();

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "DSN=Adagio Data Source; ";
try
{
conn.Open();
OdbcCommand command = conn.CreateCommand();
command.CommandText = "select * from ARTranswCust__ar92a100";

OdbcDataAdapter adapter = new OdbcDataAdapter();
adapter.SelectCommand = command;
adapter.Fill(vendorTransactions);

// Process data here.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}