topic SAS9.4 decision manager postgres access through libname in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/SAS9-4-decision-manager-postgres-access-through-libname/m-p/570883#M17533 <P>Hi,</P><P>I have SAS 9.4, and I need to create a new schema on decision manager postgresql, to use it for data integration purposes.</P><P>&nbsp;</P><P>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 "<SPAN>ERROR: CLI describe error: E</SPAN>", and I got the same error in SAS Studio...</P><P>&nbsp;</P><P>I'm attaching some snaps may be useful.</P><P>&nbsp;</P><P>Any thoughts please ??</P> Wed, 03 Jul 2019 10:15:15 GMT AhmedAccordBGro 2019-07-03T10:15:15Z SAS9.4 decision manager postgres access through libname https://communities.sas.com/t5/SAS-Data-Management/SAS9-4-decision-manager-postgres-access-through-libname/m-p/570883#M17533 <P>Hi,</P><P>I have SAS 9.4, and I need to create a new schema on decision manager postgresql, to use it for data integration purposes.</P><P>&nbsp;</P><P>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 "<SPAN>ERROR: CLI describe error: E</SPAN>", and I got the same error in SAS Studio...</P><P>&nbsp;</P><P>I'm attaching some snaps may be useful.</P><P>&nbsp;</P><P>Any thoughts please ??</P> Wed, 03 Jul 2019 10:15:15 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS9-4-decision-manager-postgres-access-through-libname/m-p/570883#M17533 AhmedAccordBGro 2019-07-03T10:15:15Z Re: SAS9.4 decision manager postgres access through libname https://communities.sas.com/t5/SAS-Data-Management/SAS9-4-decision-manager-postgres-access-through-libname/m-p/578697#M17713 Hi <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/249822">@AhmedAccordBGro</a>,<BR /><BR />Did you check this KB link?<BR /><A href="http://support.sas.com/kb/57/650.html" target="_blank">http://support.sas.com/kb/57/650.html</A><BR /><BR />similar issue was resolved for another database using ODBC. You can find the link here.<BR /><A href="https://communities.sas.com/t5/General-SAS-Programming/SAS-to-SQL-Error-via-ODBC/td-p/333086" target="_blank">https://communities.sas.com/t5/General-SAS-Programming/SAS-to-SQL-Error-via-ODBC/td-p/333086</A><BR /><BR />Thanks! Fri, 02 Aug 2019 13:39:57 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS9-4-decision-manager-postgres-access-through-libname/m-p/578697#M17713 AnandVyas 2019-08-02T13:39:57Z