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