My Oracle Support Banner

What Is Required in Order to Use Microsoft Access 2000 Database with ODI, on 64-bit Windows Operating System (Doc ID 1276550.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 to 11.1.1.7.0 [Release 10gR3 to 11gR1]
Information in this document applies to any platform.

Goal

What is required in order to use Microsoft Access 2000 database with Oracle Data Integrator (ODI), on a 64-bit Windows Operating System?

When ODI runs on 32-bit Operating System, with a 32-bit JVM, there are no issues.

But the following message is signaled when ODI is installed on a 64-bit Operating System and the connection to the Data Server from Topology Manager > Physical Architecture is tested :

How can the above be resolved?

Knowing that ODI does not provide any JDBC or ODBC driver to access Microsoft Access 2000 database, and the native Sun JDBC-ODBC bridge is used for that, the questions become:

  1. Is there any 64-bit Microsoft Access 2000 ODBC driver available?

  2. Is the Oracle Sun JDBC-ODBC bridge compatible with a 64-bit Operating System and/or JVM?

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.