Thread: Trouble with ODBC connection

Trouble with ODBC connection

From
"Daniel Łaś"
Date:
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



Re: [GENERAL] Trouble with ODBC connection

From
Byron Nikolaidis
Date:

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