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

Bug in SQLConnect, psqlodbc 08.00.00.04

From: Hajo Kirchhoff <mailinglists(at)hajo-kirchhoff(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Bug in SQLConnect, psqlodbc 08.00.00.04
Date: 2005-08-22 08:23:17
Message-ID: dec21l$bg5$1@sea.gmane.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi all,
is there a list of open bugs for psqlodbc so I don't post unneccessary 
bug reports? I couldn't find one at http://www.postgresql.org/support/

Bug description: psqlodbc 08.00.00.04, psql 8.0.1, Windows XP SP2

After the first connection attempt with SQLConnect fails, for example 
due to a bad password (State 28000), any further attempts to connect 
with the same handle always return 'Cannot connect to server', state 
08001, even if user name and password are correct. psqlodbc_ log attached.

To be able to connect to the server again I have to SQLFree the handle 
and SQLAlloc a new handle.

Hajo

Sequence for reproducing the error:

1. allocate handle
2. SQLConnect with invalid username/password
	--> returns error State 28000, Authorization failed
3. SQLConnect with valid username/password
	--> returns error State 08001, Cannot connect to server

This is the bug. A second attempt with the same handle and valid 
credentials should be able to connect to the server.

Workaround

1. allocate handle
2. SQLConnect with invalid username/password
	--> returns error State 28000
3. SQLFreeHandle
4. allocate new handle SQLAllocHandle
5. SQLConnect with valid username/password
	--> success

-- 






--------------------------------------------
Lit Window Library - Speed up GUI coding 10x
   http://www.litwindow.com/library?src=ml

wxVisualSetup - integrate wxWidgets into Visual Studio .NET
   http://www.litwindow.com/Products/products.html?src=ml

BugLister - Defect Tracker
   http://www.litwindow.com/buglister?src=ml

Tips & Tricks for wxWidgets & MS Visual Studio
   http://www.litwindow.com/Knowhow/knowhow.html?src=ml

Attachment: psqlodbc_7752.log
Description: text/plain (2.5 KB)

pgsql-odbc by date

Next:From: Timothy ReedDate: 2005-08-22 11:12:35
Subject: Re: MS Access 2000 w/ PGSQL 8.0.x
Previous:From: Jeff EckermannDate: 2005-08-22 04:24:03
Subject: Re: Unexpected ADO properties

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