topic Re: I need help connecting to ODBC server in SAS Enterprise Guide

I need help connecting to ODBC server

bn820 — Tue, 20 Aug 2024 19:40:55 GMT

I am trying to connect SAS EG to our new database through ODBC. I am using the following code:

libname odbc1 odbc noprompt= " driver={PostgreSQL Unicode(x64)};user=XXXX;
password=XXXXX ;database=D_GFC19_UA5;ds=PostgreSQL35W";

and getting the following error:

ERROR: CLI error trying to establish connection: connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection

refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections?connection to server at

"localhost" (::1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting

TCP/IP connections?”

Re: I need help connecting to ODBC server

SASKiwi — Tue, 20 Aug 2024 20:13:05 GMT

Is this the first time connecting to this server? Is SAS running on a server? What OS is SAS running on? If this is a first time connection then most likely firewall rules may need to be configured especially since you are getting connection refused messages. Talk to your SAS administrator as IT security will need to get involved.

Re: I need help connecting to ODBC server

bn820 — Wed, 21 Aug 2024 12:28:55 GMT

Yes. It's the first time connecting to this server. I will ty to reach out to IT department to inquire about any firewall restrictions that could be preventing the connection

Re: I need help connecting to ODBC server

SASKiwi — Wed, 21 Aug 2024 21:04:11 GMT

Also if your SAS Compute server runs on Windows, then you can remote into it and create a test data source in the ODBC Administrator then use the Test Connection button. That way you are taking SAS out of the loop and can demonstrate that failures are purely a data connection problem.