Thread: basic access problem on W2K

basic access problem on W2K

From
"Grzegorz Nowak"
Date:
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




Re: basic access problem on W2K

From
Justin Clift
Date:
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


Re: basic access problem on W2K

From
Jeff Ross
Date:
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


Re: basic access problem on W2K

From
"Raymond O'Donnell"
Date:
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
-------------------------------------------------------------


Re: basic access problem on W2K

From
"Nigel J. Andrews"
Date:
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


Re: basic access problem on W2K

From
"Nigel J. Andrews"
Date:

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