From: | "Eric March" <ebm(at)abs-software(dot)com(dot)au> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | WIN Connection -> ODBC -> Linux Slackware |
Date: | 2002-03-30 22:49:22 |
Message-ID: | NGBBKGNPCLCFDECPOOIHEEFDCAAA.ebm@abs-software.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | John Herreshoff | 2002-03-30 23:35:50 | Re: WIN Connection -> ODBC -> Linux Slackware |
Previous Message | Dave Page | 2002-03-30 20:45:55 | Re: psqlODBC ODBC3.0/Column Names |