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