Re: [NOVICE] Re: connecting OBDC

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: valcauda Stéphane <valcauda(dot)aderis(at)wanadoo(dot)fr>, "PostgreSQL Mailing List" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [NOVICE] Re: connecting OBDC
Date: 2002-10-01 12:45:00
Message-ID: 03AF4E498C591348A42FC93DEA9661B88479@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: valcauda Stéphane [mailto:valcauda(dot)aderis(at)wanadoo(dot)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.

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2002-10-01 12:56:56 Re: ODBC Connection : IT WORKS :)
Previous Message valcauda Stéphane 2002-10-01 12:44:50 Re: [NOVICE] Re: connecting OBDC