0 Replies Latest reply on Nov 14, 2017 5:43 AM by Chander Sharma

    Error connecting EnterpriseDB on x86_64

    Chander Sharma New Member



      I am trying to load EnterpriseDB database(postgresql), the source is a flat file.


      I am using the ODBC Driver and also have done the below entry in ODBC.ini



      Driver=path to driver/DWpsql27.so

      Description=DataDirect 7.1 Greenplum Wire Protocol





      I am getting the below error while loading the data.


      Severity Timestamp Node Thread Message Code Message

      ERROR 11/14/2017 5:59:40 PM node01_server PRE-SESS CMN_1022 Database driver error...

      CMN_1022 [

      [Informatica][ODBC PostgreSQL Wire Protocol driver]The Connect Series for ODBC PostgreSQL Wire Protocol driver is only licensed to connect to PostgreSQL databases.  You are attempting to connect to the following type of server: EnterpriseDB on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit

      Database driver error...

      Function Name : Connect

      Database driver error...

      Function Name : Connect

      Database Error: Failed to connect to database using user user_name] and connection string [name].]


      Please suggest on same.