The ODBC driver will talk to PostgreSQL 6.5

From: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: The ODBC driver will talk to PostgreSQL 6.5
Date: 1999-03-31 07:30:11
Message-ID: 93C04F1F5173D211A27900105AA8FCFC145300@lambic.prevuenet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-interfaces by date

  From Date Subject
Next Message MESZAROS Attila 1999-03-31 20:44:36 jdbc6.4 + getBigDecimal
Previous Message Yves guerin 1999-03-31 00:29:39 HowTo