PostgreSQL 9 network layer is not available. (DAC0002)

[Former Member]

Hi,

Using BO 4.1. Im getting this error when I try to edit a connection from Universe Designer:

"Unable to edit the Postgres-ODS connection: CS:Specified RDBMS is invalid: POstgreSQL 9 network layer is not available. (DAC0002)"

PostgreSQL 9 ODBC is installed fine (tried reinstall also). I see the connection works fine if I test it using ODBCAD32.exe.

The strange thing is that I do not even see an option of PostgreSQL if I try to create new connection using Universe Designer. See attached image. Tried reinstalling both 64bit and 32bit odbc drivers...not helping. ANy ideas?

[CdnConnection]

     Have you confirmed that the drivers was selected at the time of BI4 Platform install.  I would suggest you double-check by modifying the install to confirm.

Regards,

Ajay

[boudhadityapriyaranjan_ba]

Hi,

Could you please specify the version of BO4.1 installed. Could you please drill down Greenplum and check if you see the postgresql drivers there.

Thanks,