Re: connection fails

You might want to set the  tcpip_socket = true in the postgres.conf .

Regards
Zuhra Sanusi





   
                    mike@ferrar.wvsc.edu
   
                    Sent by:                     To:     andres javier garcia garcia <andresjavier.garcia@wanadoo.es>
   
                    pgsql-odbc-owner@post        cc:     pgsql-odbc@postgresql.org
   
                    gresql.org                   Subject:     Re: [ODBC] connection fails
   
                    No Phone Info
   
                    Available
   

   
                    10/25/2002 03:03 AM
   

   

   




On Thu, 24 Oct 2002, andres javier garcia garcia wrote:

Some things to check:

1. Did you add the IP address of the machine you're running Access on the
pg_hba.conf file?

2. Did you make sure the postmaster accepts tcp/ip connections?  Depending
on your version, this may involve starting postgresql with a -i option or
uncommenting some lines in the postgres.conf file.

Regards,

Mike Anderson

> Hi;
> I've just instaled the odbc driver 07.02.0003 and followed the
instructions
> given in "PostgreSQL + Access FAQ"
>
> In the part "How do I create the linked table in Access?" there is:
>
> 4. Find your data source under File Data Source or Machine Data Source
>
> The following message appears:
> ODBD:falló la llamada   (the phonecall failed)
> Could not connect to the server;
> Could not connect to the remote socket. (#101)
>
> I'm sure the IP addres is OK and the database name is OK.
> If I leave blank the Username textbox and Password textbox, nothing
happens.
> When I write down my name and password is when the aforementioned
messages
> appear.
>
>
> Thanks for your help
> -----------
> Javier
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html