Question & Answer
Question
Why does IBM DataStage ODBC connector fail with error when connecting to PostgreSQL?
ODBC function 'SQL Connect' reported: SQLSTATE=28000: Native error case= 3,732,480: Msg=[IBM(Datadirect OEM)][ODBC postgressSQL]Fatal:VFATAL; no pg_hba.conf entry for host.
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"ARM Category":[{"code":"a8m50000000L0y3AAC","label":"DataStage-\u003EJob Stages-\u003EODBC Connector"}],"ARM Case Number":"TS016147083","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.1;and future releases"}]
To view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM InfoSphere Information Server
Component:
DataStage->Job Stages->ODBC Connector
Software version:
11.7.1 and future releases
Document number:
7152784
Modified date:
25 April 2025
UID
ibm17152784
Manage My Notification Subscriptions