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
