Easysoft ODBC-ODBC Bridge

Why cannot I see my tables in Excel/Query for MAC OS X?

Article:
00918
Last Reviewed:
28th October 2008
Revision:
2

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:

DisguiseWide=1

to the data source you are using.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.