From: | John Herreshoff <jkherr(at)centurytel(dot)net> |
---|---|
To: | <ebm(at)abs-software(dot)com(dot)au>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: WIN Connection -> ODBC -> Linux Slackware |
Date: | 2002-03-30 23:35:50 |
Message-ID: | 200203302339.g2UNdUu5011178@mail3.centurytel.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Do you have a postgresql.conf file in the same directory? You need to enable
tcpip. You can do this in postgresql.conf.
HTH.
John.
On Saturday 30 March 2002 05:49 pm, Eric March wrote:
> In Win98 I go to
>
> settings -> ODBC Data Sources (32 bit) -> ABS (Driver Postgresql) ->
> configure
>
> There I get a box headed "PostgreSQL Driver Setup"
> which I have filled in as folows:
>
>
> Data Source: ABS
> Database: abs
> Server: 192.168.1.1
> User Name: postgres
> Description: Database
> Port: 5432
> Password: ********
>
> The Server is Linux Postgres compiled Feb 25
> In the directory /usr/local/pgsql/data the file
>
> pg_hba.conf has following settings
>
> # TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
> AUTH_ARGUMENT
>
> local all trust
> host all 127.0.0.1 255.255.255.255 trust
> host all 192.168.1.0 255.255.255.0 trust
>
> psql works for user postgress (2 s's) in Unix.
> I am logged onto Win98 as user ejm
>
> From XL I try to connect to external data abs and get an error message
>
> Microsoft query
> Could not connect to server;
> Could not connect to remote socket.
>
> Help please!
>
>
> Eric J March
> PO Box 475
> Hahndorf SA 5245
> Australia
>
>
> Phone 618 8389 2500
> Fax 618 8389 2488
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
From | Date | Subject | |
---|---|---|---|
Next Message | DI Hasenöhrl | 2002-03-31 09:58:37 | Re: ODBCdirect and MsAccess97 |
Previous Message | Eric March | 2002-03-30 22:49:22 | WIN Connection -> ODBC -> Linux Slackware |