Thread: Trouble with ODBC connection
I have postgresql-6.3.2 on Slackware (kernel 2.0.30). When I try to connect to database with C++ Builder BDE (Database Desktop) I achieve error messages: Could not connect to the serwer. Could not connect to remote socket. Why It doesn't work. My ODBC driver is postdrv from "Insightdist" (http://www.insightdist.com/psqlodbc). Daniel Las
Daniel £a¶ wrote: > I have postgresql-6.3.2 on Slackware (kernel 2.0.30). When I try to connect > to database with C++ Builder BDE (Database Desktop) I achieve error > messages: > Could not connect to the serwer. > Could not connect to remote socket. > > Why It doesn't work. > > Here is the ODBC Connection Checklist: ODBC Driver Data Source Checks 1.Valid and resolvable hostname. 2.Valid port number. (default is 5432) 3.Valid and existing database name. 4.Valid user name. 5.Valid password for the specified user. (Required if pg_hba.config is set to password authenticate your client.) PostgreSQL Server Checks 1.Postmaster must be running. 2.Postmaster must run with the -i option to allow remote connections. 3.The pg_hba.conf file in $PGPATH/data directory must be configured to allow your remote host to connect. Byron