Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC

2005-06-23 Thread SCassidy
cc: Subject: Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC conne

Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows

2005-06-23 Thread Hugo
hi,  if the client machine is another linux ,  what is the correct way to configure ODBC thanks Hugo  Hi,All you need is the Windows ODBC driver, which you install on the client machine, and then configure it to talk to the Linux server onport 5432 (set by default).--Ray.>> Most of the documenta

Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC connections

2005-06-23 Thread Uwe C. Schroeder
Not quite correct. TCP needs to be turned on AND an according entry in pg_hba.conf needs to be set up - otherwise the server will just decline to talk to the client. Also - if you're on XP you might want to check the "firewall" settings - which if configured wrong could potentially block connec

Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows

2005-06-23 Thread Raymond O'Donnell
On 22 Jun 2005 at 8:59, [EMAIL PROTECTED] wrote: > I have seen a bunch of different documentation on how to set up to > allow ODBC, but I am a little confused about how much/what has to be > set up to allow an ODBC connection from Windows (mostly 2003, some XP) > to an existing PostgreSQL (7.4.6)

Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC connections

2005-06-22 Thread William Yu
There's nothing on the server side that needs to be configured for Windows clients to access Postgres via ODBC. As long as TCP/IP is turned on. Just add a data source and configure the server ip/name/port/database/etc. [EMAIL PROTECTED] wrote: Hi, I have seen a bunch of different documenta

[GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows

2005-06-22 Thread SCassidy
Hi, I have seen a bunch of different documentation on how to set up to allow ODBC, but I am a little confused about how much/what has to be set up to allow an ODBC connection from Windows (mostly 2003, some XP) to an existing PostgreSQL (7.4.6) database on Linux (RedHat 9 version 2.4.20-6smp). M