Easysoft Data Access

Why do I get error "table or view does not exist" when connecting Oracle® hsODBC to SQL Server?

Article:
00932
Last Reviewed:
5th September 2007
Revision:
2

If you connect from Oracle® hsODBC to SQL Server via an Easysoft ODBC driver, select from a table (CUSTOMERS found in the Northwind sample database for instance) and get an error similar to:

SQL> select * from CUSTOMERS@hsodbc;
select * from CUSTOMERS@hsodbc
      *
ERROR at line 1:
ORA-00942: table or view does not exist
[Generic Connectivity Using ODBC]
ORA-02063: preceding 2 lines from HSODBC

It may of course be because you have mistyped the table name.

It could mean the table contains a Wide Character that the Oracle® application has problems with. To solve this, add the following attribute to the Easysoft ODBC driver data source within the odbc.ini file:

disguisewide = 1

This will allow the data to be represented within sql*plus

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.