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