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.
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 |