Loading a Redbrick Database using Redbrick ODBC driver.

[Atul73]

I am trying to load data from flat files into redbrick database using the Redbrick ODBC driver for the target database

The session is running. The session log generated shows say 3000 rows inserted for the target but actually inserts a lot less number of rows. It also shows the error message mentioned below.

Error message number CMN_1046

 

[vasa79]

CMN_1046 ODBC Error. [Merant][ODBC driver]<database>Attempt to connect to database server (<server name>) failed.]

Cause: You created an ODBC data source, but no longer have the underlying native connectivity software or environment.

Action: Reconfigure the native connectivity environment and then run the session.

or

Cause: A session with DB2 UDB EEE sources or targets failed when the Informatica Server ran on AIX and used both the Merant 3.6 ODBC driver manager and the DB2 UDB EEE CAE ODBC driver. This problem occurred because the Merant 3.6 ODBC drivermanager and the DB2 UDB EEE CAE ODBC driver are not compatible.

Action: Do not use an ODBC connection. Be sure to only use a native DB2 CAE connection to a DB2 database.