var connectionString = new OdbcConnectionStringBuilder
{
    Dsn = "HFSQL"
};

using (OdbcConnection connection = new OdbcConnection())
{
    connection.ConnectionString = connectionString.ConnectionString;
    connection.Open(); // Good !!

    // Get Data
    using (DbCommand command = new OdbcCommand("SELECT * FROM PAYE", connection))
    {
        using (var data = command.ExecuteReader())
        {
            while (data.Read())
            {
                // No problem on SELECT
                Console.WriteLine("\t{0}\t{1}", data.GetInt32(0), data.GetString(1));
            }
        }
    }

    // Get Tables
    using (var schema = connection.GetSchema("TABLES"))// Issue on GetSchema
    {
        foreach (DataRow myField in schema.Rows)
        {
            Console.WriteLine(myField["TABLE_NAME"]);
        }
    }