Re: [INTERFACES] Problem connecting NT-psqlODBC to Linux-PostgreSQL

From: Robert Hiltibidal <rob(at)y2k(dot)state(dot)il(dot)us>
To: Jelle Ruttenberg <ruttenberg(at)neroc(dot)nl>, "postgresql-interfaces" <pgsql-interfaces(at)postgreSQL(dot)org>, "postgresql-general" <postgresql-general(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] Problem connecting NT-psqlODBC to Linux-PostgreSQL
Date: 1999-09-07 13:41:33
Message-ID: 3.0.6.32.19990907084133.008fac60@y2k.state.il.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


Howdy,

Two things:

1> You might want to upgrade your post odbc driver.

2> Check your pg_hba.conf file, usually found in /usr/local/pgsql/data.
Make sure you have an entry for your NT machine. It sounds like an entry is
there but that its set to ident instewad of password. Use pg_passwd to make
a password entry for the user you are coming in as.

Hope this helps,

-Rob

>I'm trying to connect from a NT via psqlODBC (6.40.0005) to a
>Linux-machine with PostgreSQL 6.5.1 up and running. The connection is
>refused and in the logfile on the Linux-machine is the following message:
>
>Unable to connect to Ident server on the host which is trying to connect
>to Postgres (IP address 212.52.7.241, Port 113). errno = Connection
>refused (111)
>
>In the PostgreSQL-homedir there is also a file odbcinst.ini. Because I
>didn't install PostgreSQL myself, I don't know why it's there and if this
>can cause the trouble.
>
>Thanks,
>Jelle.
>
>--------------------------------------------------------------
> NEROC Publishing Solutions
>
> Jelle Ruttenberg
>
>De Run 1131, 5503 LB Veldhoven Phone : +31-(0)40-2586641
>P.O.Box 133, 5500 AC Veldhoven Fax : +31-(0)40-2541893
>The Netherlands E-mail : ruttenberg(at)neroc(dot)nl
>--------------------------------------------------------------
>
>
>************
>
>

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Wahhabi Abdelkrim 1999-09-07 15:44:06 boolean index problem
Previous Message Herouth Maoz 1999-09-07 12:51:00 Re: [GENERAL] Is there a psqlODBC for the Mac?