Generate New Database (GenNewDB) task failed with Error 'IM002: [DataDirect][ODBC lib] Data source name not found and no default driver specified' (Doc ID 487347.1)

Last updated on MARCH 04, 2016

Applies to:

Siebel Remote - Version 7.0.4 FINS [14068] and later
Generic UNIX
Version: 7.0.4 [14068] Fin Svcs
Database: All Supported
Application Server OS: IBM AIX 5L 5.1
Database Server OS: All Supported



***Checked for relevance on 22-May-2014***

Symptoms

Customer experienced the following Generic Error (Level 1) when running a Generate New Database task:

[DataDirect][ODBC lib] Data source name not found and no default driver specified
SQL Message, IM002: [DataDirect][ODBC lib] Data source name not found and no default driver specified

From the detailed component log file:


DBCLog    DBCLogError    1    000000204fe838ed:0    2012-06-25 08:54:43    [DataDirect][ODBC lib] Data source name not found and no default driver specified
GenericLog    GenericError    1    000000204fe838ed:0    2012-06-25 08:54:43    SQL Message, IM002: [DataDirect][ODBC lib] Data source name not found and no default driver specified
...
GenericLog    GenericError    1    000000204fe838ed:0    2012-06-25 08:55:43    Error in MainFunction (CreateDbTemplateFile)
GenericLog    GenericError    1    000000204fe838ed:0    2012-06-25 08:55:43    (gennewdb.cpp (610) err=524292 sys=2) SBL-GDB-00004: Error in Main function.


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