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

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

pgsql-odbc by date

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

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