Thread: Connecting

Connecting

From
Bob Pawley
Date:
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
 
 

Re: Connecting

From
Martijn van Oosterhout
Date:
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.

Attachment

Re: Connecting

From
Tony Caduto
Date:
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

Re: Connecting

From
Bob Pawley
Date:
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@amsoftwaredesign.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:
>>  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