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)