If you are having trouble getting Microsoft Excel to list your tables when using an ODBC DSN with the Data Connection Wizard, I recommend adding WorkArounds2=2097152 to see if this will solve the problem. When Microsoft Excel requests a list of catalogs using SQLTables, this option will cause the D2C ODBC Driver to return an HYC00 -- optional feature not implemented -- error, indicating that catalogs are not supported.
For more information about how to set WorkArounds2, please see http://media.datadirect.com/download/docs/odbc/allodbc/index.html#page/reference/rfi1359986381003.html.
The URL has changed. The information on WorkArounds2 with the DataDirect Cloud ODBC Driver is now at documentation.progress.com/.../index.html.
The URL has changed again. You can find the information about setting WorkArounds2 at documentation.progress.com/.../index.html.