Received: from mbg.vsnl.net.in (mbg.vsnl.net.in [202.54.12.3])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA15375
	for <pgsql-interfaces@postgresql.org>;
	Mon, 5 Jul 1999 05:59:13 -0400 (EDT)
	(envelope-from srihari@bluestar.co.in)
Received: from bsilblr2.vsnl.net.in (IDENT:root@PPP-89-15.bng.vsnl.net.in
	[202.54.89.15])
	by mbg.vsnl.net.in (8.9.1a/8.9.1) with ESMTP id PAA08954;
	Mon, 5 Jul 1999 15:35:50 +0500 (GMT+0500)
Received: from bluestar.co.in ([192.168.1.96])
	by bsilblr2.vsnl.net.in (8.8.7/8.8.7) with ESMTP id PAA27820;
	Mon, 5 Jul 1999 15:34:43 +0530
Message-ID: <378080E8.FFA2FED2@bluestar.co.in>
Date: Mon, 05 Jul 1999 15:24:48 +0530
From: srihari mule <srihari@bluestar.co.in>
Organization: BLUESTAR ISD
X-Mailer: Mozilla 4.04 [en] (Win95; I)
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
CC: srihari@bluestar.co.in
Subject: ODBC Connectivity....
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

Hi,

I am trying to connect to postgresql, I am getting an error message
'User
authentication failed #210'. Can you please help me in connecting to the
database.

I have the following installed

Client System
-------------
  1. Windows 95
  2. PostgreSQL ODBC Driver (PsqlODBC) v 06-40-0006
     (Insight Distribution Systems)
  3. MS Access 97

Server System
-------------
  1. Linux
  2. Apache Server
  3. PostgreSQL v6_4_2


ODBC Connection Checklist
--------------------------

ODBC Driver Data Source Checks
  1.Valid and resolvable hostname.
        - entered an valid hostname.
  2.Valid port number.  (default is 5432)
        - port number is set to default.
  3.Valid and existing database name.
        - database is valid and exists.
  4.Valid user name.
        - user name is valid and exists.
  5.Valid password for the specified user.
    (Required if pg_hba.config is set to password
     authenticate your client.)
        - valid password entered

PostgreSQL Server Checks
  1.Postmaster must be running.
        - Postmaster started and running.
  2.Postmaster must run with the -i option to allow remote
    connections.
        - Postmaster started with -i option.
          ( when I am trying to connect from MS Access using option
            'Get External Data' and on server side I have logged into
            the postgres account 'User authentication failed' message
            is displayed. )

  3.The pg_hba.conf file in $PGPATH/data directory must be configured
    to allow your remote host to connect.
        - checked pg_hba.conf file this has the following settings

Thankyou,

Srihari