Operating System: MAC OS X
Application: Microsoft Query X and Microsoft Excel X
Symptom: When you start a new worksheet and use Data - Get External Data - New Database Query, select a data source and click on "Show Tables" MS Query X displays the tables dialogue but no tables are shown. You can click on lines in the tables dialogue and scroll up and down but all the table names are blank.
Easysoft have identified this issue as Microsoft Query X not handling SQL_WVARCHAR column types and the MS SQL Server ODBC driver describes the table name column as SQL_WVARCHAR. To work around this you need to add:
to the data source you are using.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.