Thread: ODBC driver
I downloaded and installed the ODBC driver for Postgres. I have a linux box on the network and the postgres server is running on it. I am trying to connect to the sample database mydb from a Windows NT ver 4.0 machine though ODBC with C++ Builders BDE. I get the following errors: Unknown user name or password. Failed to authenticate client as Postgres user 'pcordone' using <unknown authentication type>: be_recvauth: unrecognized message type: 65536 Alias: PostgreSQL Can anyone help me?
On Tue, 2 Jun 1998, Peter Cordone wrote:
> I downloaded and installed the ODBC driver for Postgres. I have a linux
> box on the network and the postgres server is running on it. I am
> trying to connect to the sample database mydb from a Windows NT ver 4.0
> machine though ODBC with C++ Builders BDE.
>
> I get the following errors:
>
> Unknown user name or password.
>
> Failed to authenticate client as Postgres user 'pcordone' using <unknown
> authentication type>: be_recvauth: unrecognized
Did you create a Postgres user with the 'createuser' tool (usually run by
the postgres superuser (but not root))? This allows designated users to
use postgresql databases, and in some cases, create and destroy and even
set database permissions for other users.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
"The number of UNIX installations has grown to 10, with more expected."
-- The UNIX Programmer's Manual, 2nd Edition, June, 1972
On Tue, 2 Jun 1998, Brett W. McCoy wrote: > Did you create a Postgres user with the 'createuser' tool (usually run by > the postgres superuser (but not root))? This allows designated users to > use postgresql databases, and in some cases, create and destroy and even > set database permissions for other users. Also, don't you have to set up Postgres to accept users from another machine.. I forget exactly where you do that. Kevin -------------------------------------------------------------------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612 kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net --------------------------------------------------------------------
On Tue, 2 Jun 1998, Kevin Heflin wrote:
> > Did you create a Postgres user with the 'createuser' tool (usually run by
> > the postgres superuser (but not root))? This allows designated users to
> > use postgresql databases, and in some cases, create and destroy and even
> > set database permissions for other users.
>
> Also, don't you have to set up Postgres to accept users from another
> machine.. I forget exactly where you do that.
That'd be the pg_hba.conf file, and you can set up everything from IP
based authentication to password authentication.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
"The number of UNIX installations has grown to 10, with more expected."
-- The UNIX Programmer's Manual, 2nd Edition, June, 1972
ODBC Connection Checklist
ODBC Driver Data Source Checks
1.Valid and resolvable hostname.
2.Valid port number. (default is 5432)
3.Valid and existing database name.
4.Valid user name.
5.Valid password for the specified user. (Required iff
pg_hba.config is set to password authenticate your client.)
PostgreSQL Server Checks
1.Postmaster must be running.
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.
Peter Cordone wrote:
> I downloaded and installed the ODBC driver for Postgres. I have a linux
> box on the network and the postgres server is running on it. I am
> trying to connect to the sample database mydb from a Windows NT ver 4.0
> machine though ODBC with C++ Builders BDE.
>
> I get the following errors:
>
> Unknown user name or password.
>
> Failed to authenticate client as Postgres user 'pcordone' using <unknown
> authentication type>: be_recvauth: unrecognized
>
> message type: 65536
>
> Alias: PostgreSQL
>
> Can anyone help me?