DG4ODBC Errors When Selecting From The Following Tables - ALL_TABLES, ALL_USERS and ALL_OBJECTS

(Doc ID 1304925.1)

Last updated on MARCH 22, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 11.2 to 11.2
Information in this document applies to any platform.


Using Oracle Database Gateway for ODBC (DG4ODBC) version and DataDirect 64 bit ODBC driver version 6.1 to connect to SQL Server 2005 , running on an AIX 7.1 64 bit platform, the following errors occurs when selecting from ALL_TABLES -

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[DataDirect][ODBC 20101 driver][Microsoft SQL Server]Invalid object name
'ALL_TABLES'. {53,NativeErr = 208}[DataDirect][ODBC 20101 driver][Microsoft SQL
Server]Statement(s) could not be prepared. {60,NativeErr = 8180}


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms