Run on Windows machine, DNS-less code works fine. How to fix the DSN-less connection on Linux? I tried "Servername" and "Hostname" instead of "Server" in connection string, but it did not help. It is divided in two parts: A collector used to grab statistics on the PostgreSQL cluster using the psql command line utility and sar from the sysstat package. It is used to perform a full audit of a PostgreSQL Cluster and System performance. The error message looks strange, because I'm trying to connect a remote server, not a local one. pgCluu is a PostgreSQL performance monitoring and auditing tool. Is the server running locally and accepting connections on that socket? Run on Linux machine, this code gives me an error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory I changed my C++ code this way: SQLCHAR* cs = "DRIVER=PostgreSQL Unicode Server=192.168.11.1 Port=5432 Database=Mydb UID=postgres PWD=****" I'm trying to connect PostgreSQL from Linux by the following C++ code: SQLDriverConnectA(., "Mydb", SQL_NTS, "postgres", SQL_NTS, "****", SQL_NTS) īut I need a solution without adding any DSN ("DSN-less"). I edited /etc/odbc.ini, added the following DSN: I installed ODBC libraries and PostgreSQL ODBC driver on Linux by running the command: sudo apt-get install unixodbc unixodbc-dev odbc-postgresql You can choose to install the ODBC driver using the TGZ file, RPM package, or DEB package provided in the Snowflake Client Repository. I need to connect from Linux machine to the PostgreSQL on Windows, using C++ code by ODBC library. Installing and Configuring the ODBC Driver for Linux Linux uses named data sources (DSNs) for connecting ODBC-based client applications to Snowflake.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |