Re: [GENERAL] Trouble with ODBC connection

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