Unable to Import or Export any OFSA 4.5 IDs Due to ODBC Errors (Doc ID 161738.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

When attempting to import or export any OFSA ID the following error occurs:

(203090) Microsoft ODBC error: drv_odbc::Connect() caused ODBC Error:
State = IM002
[Microsoft] [ODBC.DLL] Data source name not found and no default driver specified.

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