Обсуждение: user authentication failed (#210)

Hello,

I tried to connect to my postgres db via odbc-Driver from within
MSAccess.

But I can not connect.
I recieve an error:
DB Access failed
user authentication failed (#210)

the following entry are in the odbc driver in Win95

Data Source: PostgreSQL
Description: PostgreSQL Test
Database: Mydb
Server: 192.168.10.123
Port: 54332
Name: postgres
Password: postgres      #this is postgres' fbsd password
                                   #not pgsql password

What is wrong here.
TIA
C.


--
Carsten Huettl - <http://www.ahorn-Net.de>
pgp-key on request

On Sat, 23 Oct 1999, Carsten Huettl wrote:

> Data Source: PostgreSQL
> Description: PostgreSQL Test
> Database: Mydb
> Server: 192.168.10.123
> Port: 54332
> Name: postgres
> Password: postgres      #this is postgres' fbsd password
>                                    #not pgsql password
>
> What is wrong here.

First of all, you want the postgresql password, NOT the freebsd password
for the 'postgres' user.

Second of all, giving a shell account the same password as it's username
is dumb, dumb, dumb.  Especially since someone could portscan you, see you
have postgresql running, and then guess the postgres account.

----------------------------------------------------------------------
Michael Allen Plump | Snorks + Kr0n = yip yip yip! | plumpy@skylab.org
"Salsa jazz music reminds me of the time my grandpa ate his left ear."
                                                          --Joe Dietz