Why do I get error "ORA-00942: table or view does not exist" when using DG4ODBC to connect to SQL Server?
You get this error for the following reasons:
- The table or view referenced in your SQL statement doesn't exist.
To check whether the table or view exists, use:
SELECT * FROM all_objects WHERE object_type IN ('TABLE','VIEW') AND object_name = '<object>';
where
<object>
is the table or view that you're trying to access. If you get "No data found" when running this query, the table or view doesn't exist. - The user you specified in your Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC)