When you choose Data > Get External Data > New Database Query, select a data source, and then choose Show Tables, Microsoft Query displays the tables dialog, but no tables are shown. You can click on lines in the tables dialog and scroll up and down, but all the table names are blank.
The reason for this is that the Microsoft SQL Server ODBC driver describes the table name column as SQL_WVARCHAR, but Microsoft Query X doesn't support SQL_WVARCHAR column types. To work around this, you need to add:
DisguiseWide=1
to your ODBC-ODBC Bridge data source.
© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
