Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole 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

conn=157889120, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info:
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,
                text_as_longvarchar=1, unknowns_as_longvarchar=0,
                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 by date

Next:From: MESZAROS AttilaDate: 1999-03-31 20:44:36
Subject: jdbc6.4 + getBigDecimal
Previous:From: Yves guerinDate: 1999-03-31 00:29:39
Subject: HowTo

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group