Message-ID: <000901be0749$cfcf50f0$0800a8c0@k150m8.univ-lyon2.fr>
From: "Patrice Espie" <patrice.espie@univ-lyon2.fr>
To: <pgsql-interfaces@postgresql.org>
Subject: I got a problem to connect !
Date: Tue, 3 Nov 1998 17:48:36 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

(from France, sorry for mistakes)

Well, I'm new on Linux, but not crazy... I think !
Could you help me connecting to my sql server from NT-ODBC ?

Thank for your answer.

>How do I report a bug or other problems?
>You can send mail to pgsql-interfaces@postgresql.org   When you do,
however, you should attach the following:

>your odbc driver version
v06-30-0250

>your postgresql database version
postgresql-6_3_2_tar.gz

>any error messages you saw on the screen
ODBC -- call failed
then
User Authentication failed (#10)

>the commlog (psqlodbc.log) file  (you will have to enable the commlog
driver option)
conn=150084832, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info:
DSN='PostgreSQL',server='192.168.0.3',port='5432',dbase='mydb',user='esppat'
,passwd='mypuce'

readonly='0',protocol='',showoid='1',fakeoidindex='1',showsystable='1'
          conn_settings=''
          translation_dll='',translation_option=''
conn=150084832,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mydb;SERVER=192.168.0.3;PORT=
5432;UID=esppat;PWD=mypuce;READONLY=0;PROTOCOL=;FAKEOIDINDEX=1;SHOWOIDCOLUMN
=1;ROWVERSIONING=1;SHOWSYSTEMTABLES=1;CONNSETTINGS='
Global Options: Version='06.30.0250', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=4094
                disable_optimizer=1, unique_index=1, use_declarefetch=1
                text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
                extra_systable_prefixes='dd_;', conn_settings=''
ERROR from backend during authentication: 'User authentication failed'
CONN ERROR: func=SQLDriverConnect, desc='Error from CC_Connect', errnum=10,
errmsg='User authentication failed'
            ------------------------------------------------------------
            henv=150084816, conn=150084832, status=0, num_stmts=16
            sock=150079040, stmts=150079088, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=340, reverse=0, errornumber=0, errormsg='(null)'
            buffer_in=150091128, buffer_out=150095232
            buffer_filled_in=28, buffer_filled_out=0, buffer_read_in=28

>the odbc trace log (sql.log) file (if the problem warrants it)
it's empty :>

To be sure of what I'm doing, I've just done:
#destroyuser (specifiyng esppat)
#su postgres
#createuser (specifiyng esppat which can create db and add user)
and then try again to connect from MS Access 97 under (T)NT.

When I try to link external tables from external db, I get the messages
explain above.

What is the trick ?
Thank's a lot.

/*--------------------*/
Patrice Espié
Institut de Psychologie
Université Lumière Lyon2
Lyon - France
Patrice.Espie@univ-lyon2.fr
http://perso.wanadoo.fr/patrice.espie