I got a problem to connect !
От | Patrice Espie |
---|---|
Тема | I got a problem to connect ! |
Дата | |
Msg-id | 000901be0749$cfcf50f0$0800a8c0@k150m8.univ-lyon2.fr обсуждение исходный текст |
Список | pgsql-interfaces |
(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
В списке pgsql-interfaces по дате отправления: