WIN Connection -> ODBC -> Linux Slackware

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

Responses

Browse pgsql-odbc by date

  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