https://communities.sas.com/t5/New-SAS-User/Problem-with-connection-ODBC-to-PostgreSQL-and-Proc-Metalib/m-p/826109#M35258 <P>Good morning,</P><P>I'm new to SAS and i have the following problem. I'm trying to connect with data base PostagreSQL trought ODBC, In the managment console after register tables i'm going trough the first step, tables in data base are visible but after choosing the particular table and clicking finish&nbsp;"ERROR: Invalid option name =." appears, which is preceded with "NOTE: 61 table(s) not displayed/returned because the name is too long." and the proc metalib procedure after which the mentioned ERROR appears. N<SPAN>ames are less than 32 characters long.</SPAN> I want to add that after registration of the library in enterprise guide mentioned tables are visible and i can display them but the proc metalib procedure doesn't work there as well. Does anybody know what causes the error? I'll be grateful for your help.</P><P>&nbsp;</P> Fri, 29 Jul 2022 07:24:49 GMT D_User 2022-07-29T07:24:49Z https://communities.sas.com/t5/New-SAS-User/Problem-with-connection-ODBC-to-PostgreSQL-and-Proc-Metalib/m-p/826109#M35258 <P>Good morning,</P><P>I'm new to SAS and i have the following problem. I'm trying to connect with data base PostagreSQL trought ODBC, In the managment console after register tables i'm going trough the first step, tables in data base are visible but after choosing the particular table and clicking finish&nbsp;"ERROR: Invalid option name =." appears, which is preceded with "NOTE: 61 table(s) not displayed/returned because the name is too long." and the proc metalib procedure after which the mentioned ERROR appears. N<SPAN>ames are less than 32 characters long.</SPAN> I want to add that after registration of the library in enterprise guide mentioned tables are visible and i can display them but the proc metalib procedure doesn't work there as well. Does anybody know what causes the error? I'll be grateful for your help.</P><P>&nbsp;</P> Fri, 29 Jul 2022 07:24:49 GMT https://communities.sas.com/t5/New-SAS-User/Problem-with-connection-ODBC-to-PostgreSQL-and-Proc-Metalib/m-p/826109#M35258 D_User 2022-07-29T07:24:49Z https://communities.sas.com/t5/New-SAS-User/Problem-with-connection-ODBC-to-PostgreSQL-and-Proc-Metalib/m-p/826110#M35259 <P>Have a look at <A href="https://support.sas.com/kb/57/935.html" target="_blank">https://support.sas.com/kb/57/935.html</A>.</P> <P>&nbsp;</P> Fri, 29 Jul 2022 07:37:56 GMT https://communities.sas.com/t5/New-SAS-User/Problem-with-connection-ODBC-to-PostgreSQL-and-Proc-Metalib/m-p/826110#M35259 andreas_lds 2022-07-29T07:37:56Z https://communities.sas.com/t5/New-SAS-User/Problem-with-connection-ODBC-to-PostgreSQL-and-Proc-Metalib/m-p/826112#M35260 i've tried this before unforunately its not the reason. I've deleted special characters everywhere. Fri, 29 Jul 2022 07:58:42 GMT https://communities.sas.com/t5/New-SAS-User/Problem-with-connection-ODBC-to-PostgreSQL-and-Proc-Metalib/m-p/826112#M35260 D_User 2022-07-29T07:58:42Z