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

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

Products
- Easysoft ODBC-ODBC Bridge
- Easysoft ODBC-SQL Server Driver
Applications
- Oracle

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft Data Access

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

Applies To

Knowledge Base Feedback