Thread: basic access problem on W2K
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
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
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
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 -------------------------------------------------------------
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
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