Hello there! I came across a problem connecting SAS to PostgreSQL via SAS ACCESS to ODBC. I had some drivers in <sashome>/SASODBCDriversfortheWebInfrastructurePlatformDataServer/9.4/Driver, but psqlodbcw.so and psqlodbca.so returned data in UTF-8, but I need ANSI. SAS accept them. After I installed the new postgresODBC drivers https://download.postgresql.org/pub/repos/yum/13/redhat/rhel-8.5-x86_64/postgresql13-odbc-13.02.0000-1PGDG.rhel8.x86_64.rpm But SAS refuses to accept them: """ERROR: CLI error trying to establish connection: [unixODBC] could not connect to server: No such file or directory. Is the server running locally and accepting connections on Unix domain socket '/tmp/.s.PGSQL.5432'? """ The request via console isql/iusql passes normally, odbc.ini is the same. isql/iusql returns both in UTF-8 or ANSI, but SAS refuses to work. Parameters: System: x86_64 RHEL 8.6 Session encoding SAS - KZ1048, Encoding DB - UTF-8, Postgres DB - v13.6 on a remote server x86_64 RHEL 8.5.0-4 unixODBC - v2.3.4 Which version of postgresODBC is better to use, or how to solve the problem of getting data in ANSI? Changing the encoding of the SAS session, changing the encoding of the database, using DataDirect is not suitable yet((
... View more