WIN Connection -> ODBC -> Linux Slackware - Mailing list pgsql-odbc

From Eric March
Subject WIN Connection -> ODBC -> Linux Slackware
Date
Msg-id NGBBKGNPCLCFDECPOOIHEEFDCAAA.ebm@abs-software.com.au
Whole thread Raw
Responses Re: WIN Connection -> ODBC -> Linux Slackware  (John Herreshoff <jkherr@centurytel.net>)
List 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



pgsql-odbc by date:

Previous
From: Dave Page
Date:
Subject: Re: psqlODBC ODBC3.0/Column Names
Next
From: John Herreshoff
Date:
Subject: Re: WIN Connection -> ODBC -> Linux Slackware