5 Replies Latest reply on May 21, 2013 8:23 PM by 956835

    Informatica Workflow Manager ODBC Relational Connection for ETL in DAC

      In Informatica Workflow Manager, I have created a Relational Connection of type ODBC and specified Connect String as "DSN=BIEEDW" where "BIEEDW" is the System ODBC DSN already set pointing to a SQL Server 2008 database.

      However, when the ETL run in DAC, the following error occurs in Session log files showing that the database and driver cannot be located:

      MAPPING> CMN_1569 Server Mode: [UNICODE]
      MAPPING> CMN_1570 Server Code page: [MS Windows Traditional Chinese, superset of Big 5]
      MAPPING> TM_6151 The session sort order is [Binary].
      MAPPING> TM_6156 Using low precision processing.
      MAPPING> TM_6180 Deadlock retry logic will not be implemented.
      MAPPING> TM_6187 Session target-based commit interval is [10000].
      MAPPING> TM_6307 DTM error log disabled.
      MAPPING> TE_7022 TShmWriter: Initialized
      MAPPING> DBG_21075 Connecting to database [DSN=BIEEDW], user [bieedw02]
      MAPPING> CMN_1761 Timestamp Event: [Wed May 22 01:29:17 2013]
      MAPPING> CMN_1022 Database driver error...
      CMN_1022 [
      [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      Database driver error...
      Function Name : Connect
      Database driver error...
      Function Name : Connect
      Database Error: Failed to connect to database using user [bieedw02] and connection string [DSN=BIEEDW].]

      Any hint in setting the Connect String for ODBC Relational Connection?