PostgreSQL Discussion

Author

Connecting

Bob Pawley

2006-03-29, 9:28 am

I have been attempting to connect to a database (Postgresql 8.0, running on XP.

I have two different applications that see and apparently connect to the Postgresql ODBC driver (version - psqlodbc-08_00_0101) but I receive an error message when attempting to connect.

Do I somehow have the wrong driver for my version of Postgresql or is there something in Postgresql that I need to switch on???

Bob Pawley

Martijn van Oosterhout

2006-03-29, 9:28 am

On Wed, Mar 29, 2006 at 06:08:44AM -0800, Bob Pawley wrote:
> I have been attempting to connect to a database (Postgresql 8.0, running on XP.
>
> I have two different applications that see and apparently connect to
> the Postgresql ODBC driver (version - psqlodbc-08_00_0101) but I
> receive an error message when attempting to connect.

You're going to have to tell us the error message if you want any help.
Our mind-reading devices are offline today.

Have a ncie day,

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Tony Caduto

2006-03-29, 11:28 am

Bob Pawley wrote:
>
> Do I somehow have the wrong driver for my version of Postgresql or is
> there something in Postgresql that I need to switch on???
>
> Bob Pawley
>
>
Hi Bob,
Make sure you have the listen_addresses setting in postgresql.conf set to *

listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all

Also make sure you have a entry in the pg_hba.conf file that allows your
remote host to connect, you can either specify a explicit host or you
can allow whole subnets access.

These files are located(at least on my PC :-) :C:\Program
Files\PostgreSQL\8.1\data

Hope this helps,

Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Bob Pawley

2006-03-29, 11:28 am

Thanks Tony I found it.

Can you give me a hint as to how to open the file??

Bob
----- Original Message -----
From: "Tony Caduto" < tony_caduto@amsoftwa
redesign.com>
To: "Bob Pawley" <rjpawley@shaw.ca>; <pgsql-general@postgresql.org>
Sent: Wednesday, March 29, 2006 8:12 AM
Subject: Re: [GENERAL] Connecting

> Bob Pawley wrote:
> Hi Bob,
> Make sure you have the listen_addresses setting in postgresql.conf set to
> *
>
> listen_addresses = '*' # what IP address(es) to listen on;
> # comma-separated list of addresses;
> # defaults to 'localhost', '*' = all
>
> Also make sure you have a entry in the pg_hba.conf file that allows your
> remote host to connect, you can either specify a explicit host or you can
> allow whole subnets access.
>
> These files are located(at least on my PC :-) :C:\Program
> Files\PostgreSQL\8.1\data
>
> Hope this helps,
>
> Tony Caduto
> AM Software Design
> http://www.amsoftwaredesign.com
> Home of PG Lightning Admin for Postgresql
> Your best bet for Postgresql Administration
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links