Обсуждение: Trouble with ODBC connection

Поиск
Список
Период
Сортировка

Trouble with ODBC connection

От
"Daniel Łaś"
Дата:
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

От
Byron Nikolaidis
Дата:

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