Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org
	(8.8.8/8.7.5) with ESMTP id KAA20665 for
	<pgsql-interfaces@postgreSQL.org>;
	Thu, 28 May 1998 10:56:52 -0400 (EDT)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.8.5/8.8.5(+AntiRelay)) with UUCP id KAA13032
	for pgsql-interfaces@postgreSQL.org;
	Thu, 28 May 1998 10:46:00 -0400 (EDT)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!daveh using -f
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA33592; Thu, 28 May 1998 10:29:56 -0400
Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA80612; Thu, 28 May 1998 10:29:56 -0400
Message-Id: <356D745B.6B9D53B@insightdist.com>
Date: Thu, 28 May 1998 10:27:39 -0400
From: David Hartwig <daveh@insightdist.com>
Organization: Insight Distribution Systems
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: duncanlo@m2.dj.net.tw, pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [ADMIN] pgsql-interfaces ODBC???
References: <356AD040.D468CD38@m2.dj.net.tw>
	<356AE3D2.945C8119@insightdist.com>
	<356CE8EE.1449407A@m2.dj.net.tw>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Is the user name valid.  If so, are you set up properly in pg_hba.conf file in
$PGPATH/data directory on the server.  If so, did you specify password
authentication for your remote machine?   If so, you MUST supply a correct
password.  I don't think unpassworded accounts will work.

In the future, please post your questions to the list.

Thanks for checking us out.

ªü$¡·

> Thank you!
> I add -i option, then is ok. But now I have "User authentiction failed (#10)".
>
> Is this problem about pg_hba.conf?
>
> >        5. Valid password for the specified user.  (Required iff
> >           pg_hba.config is set to password authenticate your client.)
> >    * PostgreSQL Server Checks
> >        2. Postmaster must run with the -i option to allow remote
> >           connections.
> >        3. The pg_hba.conf file in $PGPATH/data directory must be
> >           configured to allow your remote host to connect.
> > > I had install PostgreSQL 6.3.1 in Slackware Linux(kernel 2.0.33)
> > > Now I install PostgreSQL ODBC Driver in another PC.
> > > When I import/export data with ODBC Driver.
> > > It said "ODBC Error!" then print some message...
> > >   Could not connect to the server.
> > >   Could not connect to remote socket (#1)
> > > Where is my error? Thank you!