(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