Last updated on JULY 18, 2014
Applies to:Oracle ODBC Driver - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Oracle ODBC Driver - Version 188.8.131.52 and later
Microsoft Windows x64 (64-bit)
Database link hangs when attempting to link a table from Microsoft Access 2010 to Oracle database using Oracle ODBC driver.
The issue can be consistently reproducible with below scenario.
1. Have 2 databases, Local database (A) and remote database (B). Create a database link between the 2 databases.
2. Create a public synonym in database A for a view in database B.
3. Using MS Access, create a linked table to consume public synonym from database A.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms