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

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

If you:

  1. Connect from Oracle HSODBC to SQL Server by using an Easysoft ODBC driver
  2. Select from a table
  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

You may have mistyped the table name.

Alternatively, it could mean the table contains a wide character that the Oracle application has problems with. To work around this, add the following attribute to the Easysoft ODBC driver data source in odbc.ini:

disguisewide = 1