Thread

1. basic access problem on W2K

   Grzegorz Nowak <grzegorz.nowak@wp.pl> — 2003-01-31T22:29:20Z

   Hi there!
   
   I installed PGSQL downloaded from http://prdownloads.sourceforge.net/pgsql/
   I can start the server, enter command line, create and drop databases and
   tables.
   
   However, I CANNOT ACCESS PGSQL from any other application (BC++ Builder, MS
   Access,
   ISO PGSQL,...).
   
   I specified port 5423 as the database port.
   For now, I am fine with running tha database
   as localhost, but I would prefer to have it accessible from the network.
   
   Can somebody help ? How do I get access to PGSQL from any other software ?
   
   Thanks!
   Greg
   
   
   
   
   

2. Re: basic access problem on W2K

   Justin Clift <justin@postgresql.org> — 2003-02-02T10:16:16Z

   Grzegorz Nowak wrote:
   >
   > Hi there!
   > 
   > I installed PGSQL downloaded from http://prdownloads.sourceforge.net/pgsql/
   > I can start the server, enter command line, create and drop databases and
   > tables.
   > 
   > However, I CANNOT ACCESS PGSQL from any other application (BC++ Builder, MS
   > Access,
   > ISO PGSQL,...).
   > 
   > I specified port 5423 as the database port.
   > For now, I am fine with running tha database
   > as localhost, but I would prefer to have it accessible from the network.
   > 
   > Can somebody help ? How do I get access to PGSQL from any other software ?
   
   It sounds like you need to install the PostgreSQL ODBC drivers, and 
   setup some data sources:
   
   http://gborg.postgresql.org/project/psqlodbc/projdisplay.php
   
   Hope that helps.
   
   :-)
   
   Regards and best wishes,
   
   Justin Clift
   
   
   > Thanks!
   > Greg
   
   
   -- 
   "My grandfather once told me that there are two kinds of people: those
   who work and those who take the credit. He told me to try to be in the
   first group; there was less competition there."
   - Indira Gandhi
   
   
   

3. Re: basic access problem on W2K

   Jeff Ross <jross@openvistas.net> — 2003-02-02T16:50:12Z

   On Fri, 31 Jan 2003, Grzegorz Nowak wrote:
   
   > Hi there!
   >
   > I installed PGSQL downloaded from http://prdownloads.sourceforge.net/pgsql/
   > I can start the server, enter command line, create and drop databases and
   > tables.
   >
   > However, I CANNOT ACCESS PGSQL from any other application (BC++ Builder, MS
   > Access,
   > ISO PGSQL,...).
   >
   > I specified port 5423 as the database port.
                      ^^^^
   > For now, I am fine with running tha database
   > as localhost, but I would prefer to have it accessible from the network.
   >
   > Can somebody help ? How do I get access to PGSQL from any other software ?
   >
   > Thanks!
   > Greg
   >
   >
   >
   >
   > ---------------------------(end of broadcast)---------------------------
   > TIP 4: Don't 'kill -9' the postmaster
   >
   
   Just a thought...should your port be 5432 instead?
   
   -- 
   Jeff Ross
   Open Vistas Networking, Inc.
   http://www.openvistas.net
   
   
   

4. Re: basic access problem on W2K

   Raymond O'Donnell <rod@iol.ie> — 2003-02-02T20:32:57Z

   On 31 Jan 2003 at 23:29, Grzegorz Nowak wrote:
   
   > However, I CANNOT ACCESS PGSQL from any other application (BC++ Builder,
   > MS Access, ISO PGSQL,...).
   
   Did you start Postgres with the -i option? It won't accept TCP/IP 
   connections without that.
   
   --Ray.
   
   
   -------------------------------------------------------------
   Raymond O'Donnell     http://www.galwaycathedral.org/recitals
   rod@iol.ie                          Galway Cathedral Recitals
   -------------------------------------------------------------
   
   
   

5. Re: basic access problem on W2K

   Nigel J. Andrews <nandrews@investsystems.co.uk> — 2003-02-02T20:54:28Z

   On Sun, 2 Feb 2003, Raymond O'Donnell wrote:
   
   > On 31 Jan 2003 at 23:29, Grzegorz Nowak wrote:
   > 
   > > However, I CANNOT ACCESS PGSQL from any other application (BC++ Builder,
   > > MS Access, ISO PGSQL,...).
   > 
   > Did you start Postgres with the -i option? It won't accept TCP/IP 
   > connections without that.
   > 
   
   I don't know about BC++ Builder and ISO whatever but surely MS Access uses
   odbc. So have you got odbc available and configured?
   
   
   -- 
   Nigel J. Andrews
   
   
   

6. Re: basic access problem on W2K

   Nigel J. Andrews <nandrews@investsystems.co.uk> — 2003-02-02T20:57:17Z

   
   Ah, I saw too late that you'd trimed the original posters email from the
   headers so it's only gone to you and the list. The accepted practice is to
   reply to individuals and the list that way timely delivery is more likely.
   
   Nigel Andrews