Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

Next:From: John HerreshoffDate: 2002-03-30 23:35:50
Subject: Re: WIN Connection -> ODBC -> Linux Slackware
Previous:From: Dave PageDate: 2002-03-30 20:45:55
Subject: Re: psqlODBC ODBC3.0/Column Names

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group