My Oracle Support Banner

DG4ODBC Errors When Selecting From The Following Tables - ALL_TABLES, ALL_USERS and ALL_OBJECTS (Doc ID 1304925.1)

Last updated on AUGUST 04, 2018

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}


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.