Why do I get error "table or view does not exist" when connecting Oracle HSODBC to SQL Server?
If you:
- Connect from Oracle HSODBC to SQL Server by using an Easysoft ODBC driver
- Select from a table
- 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