Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

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:
4th January 2024
Revision:
3

If you:

  1. Connect from Oracle hsODBC to SQL Server via an Easysoft ODBC driver
  2. Select from a table (CUSTOMERS found in the Northwind sample database for instance)
  3. 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)