Re: [NOVICE] Re: connecting OBDC - Mailing list pgsql-odbc

From Dave Page
Subject Re: [NOVICE] Re: connecting OBDC
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B88479@mail.vale-housing.co.uk
Whole thread Raw
In response to [NOVICE] Re: connecting OBDC  (valcauda Stéphane <valcauda.aderis@wanadoo.fr>)
List pgsql-odbc

> -----Original Message-----
> From: valcauda Stéphane [mailto:valcauda.aderis@wanadoo.fr]
> Sent: 01 October 2002 13:45
> To: Dave Page; PostgreSQL Mailing List
> Subject: Re: [NOVICE] Re: [ODBC] connecting OBDC
>
>
> No, It wasn't -i with postmaster and TCP/IP socket was by
> default (so False). It makes me think of another thing.
>
> All is on my personnal computer : Windows 2000 workstation
> and CYGWIN. I had made the default CYGWIN installation. But
> does Windows 2000 ODBC drivers can communicate with CYGWIN
> postgreSQL session with TCP/IP. Should I install something
> else to make W2000 / CYGWIN be compatible under IP ?

No, that should work fine. Here's a checklist:

1) Start the postmaster with -i or tcpip_socket=true in $PGDATA/postgresql.conf
2) Make sure there in an entry in $PGDATA/pg_hba.conf that will allow you access eg.

host         all           all       127.0.0.1     255.255.255.255    password

3) Make sure tcp/ip is installed on your workstation (pretty hard not to these days).
4) Setup a system DSN for testing:

Server:   127.0.0.1
Database: template1

All other options can be left at their defaults for testing.

Regards, Dave.

pgsql-odbc by date:

Previous
From: valcauda Stéphane
Date:
Subject: Re: [NOVICE] Re: connecting OBDC
Next
From: valcauda Stéphane
Date:
Subject: ODBC Connection : IT WORKS :)