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: 93C04F1F5173D211A27900105AA8FCFC145300@lambic.prevuenet.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group