Getting Cannot Find ODBC.DLL Error During Export in OFSA 4.5 (Doc ID 727908.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Balance & Control (BC) - Version: 4.5
Oracle Performance Analyzer (PA) - Version: 4.5
Oracle Risk Manager (RM) - Version: 4.5
Oracle Transfer Pricing (TP) - Version: 4.5
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

In Oracle Financial Services Applications (OFSA) 4.5, when you try to export an OFSA ID, you receive the following errors:

File Error
Cannot find ODBC.DLL


followed by:

Error: session::AttachDB()
Error Loading Database Driver DLL


You have already reviewed <Note:161738.1> "Unable to Import or Export any OFSA IDs Due to ODBC Errors".  Your setup is correct.

Steps to replicate:

1. Log into an OFSA module (Ex. Oracle Performance Analyzer)
2. Open an OFSA ID (ex. Tree Rollup ID, Allocation ID, etc.)
3. Select "File" > "Export"
4. Enter the export file name and click OK

The error appears.

Cause

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