Error "[Microsoft][ODBC Microsoft Access Driver] ODBC connection to <connection string>' failed". (4223926)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Error "[Microsoft][ODBC Microsoft Access Driver] ODBC connection to ' failed".
Beschreibung

On attempting to run a heterogeneous query in Query Builder between an Oracle table and Access table, the following error occurs
"[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to <connection string>' failed".
or in later versions of Toad:
"Direct Connections can not be used with cross-connection queries. Please use an Oracle Client connection..."
Ursache

A Direct Oracle connection is made to connect to server which is not supported in cross-connection queries
Lösung

To use an Oracle connection in a cross-connection query, you must install an Oracle ODBC driver. See 'Create Oracle Connections' in the Help for more information.
Note: The Oracle Full Install client includes an ODBC driver. However, if you are using the Oracle Instant client (which may not include an ODBC driver), you may also need to install an Oracle ODBC driver.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel