Обсуждение: ODBC fails connection

I've got MSAccess2000 under WindowsXP and Postgresql7.2 under Linux.
And I would like to use Access as a client.
I've dowloaded the ODBC driver7.2 and when I try to make a source of data I
have three optional drivers:
    PostgreSQL  7.02.00.03
    PostgreSQL+(Beta)  7.02.00.03
    PostgreSQL+Unicode (Beta)  7.02.00.03
I've chosen the first one and I have to fill in several fields in a dialog
window. Here are the fields and my questions:

Data Source: PostgreSQL          ->   Right?
Database: Name_of_my_POstgreSQL_database   -> Right?
Server: IP address of my Linux machine   -> Right?
Port:                       Don't know?
User Name:              Does this user need to be created in the database and
also as a Linux machine users?
Password:             The same question
----------------------------------
I've created a PostgreSQL user but when I try to connect from ACCESS I open
ODBCdatabases; choose Equipment data sources; choose the PostgreSQL (Sistem)
Data source; Accept; and apears a dialog; where I fill in a user name and a
password; butget the following message:

ODBC: fallo la llamada           ->  (the call failed)
Could not connect to the server;
Could not connect to remote socket (#101)
-----------
Please. Any help?


Regards

--
A. Javier García
Water and Soil Conservation Department
CEBAS-CSIC
Apartado 4195
30080 Murcia
Spain

Tel.: +34 968 39 63 90
Fax: +34 968 39 62 13

> ODBC: fallo la llamada           ->  (the call failed)
> Could not connect to the server;
> Could not connect to remote socket (#101)
> -----------
> Please. Any help?

Hola! Hello!

    you must also start the daemon width the "-i" option

    _____    - - - - - - - - - Alejandro Alfonso Fernández - - - - - - - - -
   /\___/\   Grupo Universitario de Informática - Diplomatura en Estadística
  /__\ _\/   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 /_/\_\      - "Lo mejor de tu ordenador está entre tu silla y tu teclado" -
/_/ /\_\      Atari Php Asp Wap Sql Dhtml Swf JavaScript Java Xml C Awk Sed
\_\/  \_\    - Email: kawa@gui.uva.es - Web: http://www.gui.uva.es/~kawa/  -
L.Carrol:   Hace falta que corras todo lo que puedas para seguir en el mismo
sitio. Si quieres ir a alguna parte, ­tendras que correr el doble de rapido!
*gpg*public*key->http://www.gui.uva.es/%7ekawa/alexokawa.gpg<-gpg*public*key

On 17 Dec 2002 at 13:26, javier garcia wrote:

> Data Source: PostgreSQL          ->   Right?

This is the name of the DSN which you set up on the client machine -
make sure it's a "system DSN" rather than a "user DSN".

> Database: Name_of_my_POstgreSQL_database   -> Right?

No - the name of the database on the Linux machine.

> Server: IP address of my Linux machine   -> Right?

Right.

> Port:                       Don't know?

5432 is the default Postgres port, unless you've changed it on the
Linux machine for some reason.

> User Name:              Does this user need to be created in the
> database and also as a Linux machine users?

No - only in the database.

> Password:             The same question

Same answer!

> ODBC: fallo la llamada           ->  (the call failed)
> Could not connect to the server;
> Could not connect to remote socket (#101)

Make sure that you start Postmaster with the -i option, otherwise it
won't accept TCP/IP connections.

HTH!

--Ray.

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------

> -----Original Message-----
> From: Raymond O'Donnell [mailto:rod@iol.ie]
> Sent: 17 December 2002 12:59
> To: javier garcia; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] ODBC fails connection
>
>
> make sure it's a "system DSN" rather than a "user DSN".

Why?

Regards, Dave.