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

Re: [GENERAL] Setting up Postgresql on Linux

2004-06-09 Thread Paul Thomas
On 01/03/2004 23:22 Phil Campaigne wrote: Hello, I originally installed postgresql as root user and now I am setting up a development environment with cvs and a java ide and tomcat. I have everything with the exception of postgresql integreted using a non-root user. THe process I am using is to

Re: [GENERAL] Setting up Postgresql on Linux

2004-03-04 Thread scott.marlowe
On Thu, 4 Mar 2004, phil campaigne wrote: > Hello, > when I login to linux and check the env's I see: > PATH=/usr/local/pgsql/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/home/postgres/bin:/opt/IBMJava2-14/bin:/opt/IBMJava2-14/jre/bin:/usr/local/pgsql/bin > LD_LIBRARY_PATH=/usr/lo

Re: [GENERAL] Setting up Postgresql on Linux

2004-03-03 Thread Ron St-Pierre
Phil Campaigne wrote: Hi Ron, I had a couple of questions on your instructions: 1. what is this for? >#make install-all-headers According to the docs you need it if you are going to create your own functions, however the documentation is a bit *vague*. "If you plan to do any server-side program

Re: [GENERAL] Setting up Postgresql on Linux

2004-03-02 Thread Ron St-Pierre
Phil Campaigne wrote: Hello, I originally installed postgresql as root user and now I am setting up a development environment with cvs and a java ide and tomcat. I have everything with the exception of postgresql integreted using a non-root user. THe process I am using is to logon as postges a

Re: [GENERAL] Setting up Postgresql on Linux

2004-03-02 Thread scott.marlowe
On Mon, 1 Mar 2004, Phil Campaigne wrote: > Hello, > I originally installed postgresql as root user and now I am setting up a > development environment with cvs and a java ide and tomcat. I have > everything with the exception of postgresql integreted using a non-root > user. > THe process I am