SAS9.4 decision manager postgres access through libname

[AhmedAccordBGro]

Hi,

I have SAS 9.4, and I need to create a new schema on decision manager postgresql, to use it for data integration purposes.

I got my ODBC working, DSN entry, Libname working fine, test the connection is perfect, even I can see the table names during "Register Tables" wizard, BUT register table abort with error "ERROR: CLI describe error: E", and I got the same error in SAS Studio...

I'm attaching some snaps may be useful.

Any thoughts please ??

[Anand_V]

Hi @AhmedAccordBGro,

Did you check this KB link?
http://support.sas.com/kb/57/650.html

similar issue was resolved for another database using ODBC. You can find the link here.
https://communities.sas.com/t5/General-SAS-Programming/SAS-to-SQL-Error-via-ODBC/td-p/333086

Thanks!