Problems Connecting To Ms Access Using Dg4odbc

(Doc ID 1195583.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


You are using DG4ODBC on Windows and RDBMS on Linux x86 to select from Access tables.
A select gives the following error -

SQL> select * from batch@dg4odbc;
select * from batch@dg4odbc
ERROR at line 1:
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from DG4ODBC

The database link has been created without a user and password -

create database link dg4odbc using 'dg4odbc' ;

However, using the same Access mdb file and setup on an Oracle test system allowed the select to work. 


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