The ODBC driver will talk to PostgreSQL 6.5
От | Michael Davis |
---|---|
Тема | The ODBC driver will talk to PostgreSQL 6.5 |
Дата | |
Msg-id | 93C04F1F5173D211A27900105AA8FCFC145300@lambic.prevuenet.com обсуждение исходный текст |
Список | pgsql-interfaces |
I have installed version 6.5 of PostgreSQL. I can't seem to get Access97 (or any ODBC client) to access the database. Here is the error from the log file: conn=157889120, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1 DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='postgres ',passwd='' readonly='0',protocol='6.5',showoid='0',fakeoidindex='0',showsystable='0' conn_settings='' translation_dll='',translation_option='' Global Options: Version='06.50.0000', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=4094 disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0 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=210, errmsg='User authentication failed' ------------------------------------------------------------ henv=157889104, conn=157889120, status=0, num_stmts=16 sock=157895456, stmts=157903712, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=316, reverse=0, errornumber=0, errormsg='(null)' buffer_in=157895504, buffer_out=157899608 buffer_filled_in=28, buffer_filled_out=0, buffer_read_in=28 This also happened before I made the following changes to the ODBC driver: - I used regedit and changed all 6.4 references to 6.5 - I changed all 6.4, PG64, and DS_PG64 references in the header files and c source code files to equivalent 6.5 references - Recompiled psqlodbc.dll and installed it in c:\winnt\system32 How can I get the ODBC driver to talk to version 6.5? I am running Access97 on Windows NT 4.0 on the client, and Red Hat 5.1, PostgreSQL 6.5 on intel for the server. I have verified that I can connect to the server and access all files with several different users. This worked, before the above changes, with 6.4.2. Thanks, Michael
В списке pgsql-interfaces по дате отправления: