Обсуждение: connection fails
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
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 >
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