basic access problem on W2K

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