Re: [ADMIN] pgsql-interfaces ODBC???

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!