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

    Error connecting EnterpriseDB 9.6.5.10 on x86_64

    Chander Sharma New Member

      Hello,

       

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

       

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

       

      [name]

      Driver=path to driver/DWpsql27.so

      Description=DataDirect 7.1 Greenplum Wire Protocol

      Database=db_name

      Hostname=host_ip

      PortNumber=port_no

       

      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 9.6.5.10 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.