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