[ psqlodbc-Bugs-1000611 ] Empty exception thrown when no password supplied - Mailing list pgsql-odbc

From
Subject [ psqlodbc-Bugs-1000611 ] Empty exception thrown when no password supplied
Date
Msg-id 20060418032532.E62E986C59A@pgfoundry.org
Whole thread Raw
List pgsql-odbc
Bugs item #1000611, was opened at 2006-04-13 09:16
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000611&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Patrick Donelan (patspam)
Assigned to: Hiroshi Inoue (hinoue)
Summary: Empty exception thrown when no password supplied

Initial Comment:
Experimental Enhanced Branch psqlODBC 07.03.0260 throws an empty ODBCException when you try to connect without
specifyinga password in the connection string. 

I am submitting this as a bug because the non-experimental psqlodbc branch would throw an ODBCException with an
exceptionmessage along the lines of "no password supplied" which you could use to diagnose the problem. 

I am running psqlODBC 07.03.0260 under Windows XP. My code is running C# with Visual Studio 2005.

Sample code to reproduce:
using System.Data.Odbc;
// specify connection string without pwd
string c =
"Driver={PostgreSQL+};database=mydb;server=localhost;port=5432;sslmode=prefer;uid=myuid;readonly=0;protocol=6.4;fakeoidindex=0;showoidcolumn=0;rowversioning=0;showsystemtables=0;fetch=100;socket=8192;unknownsizes=0;maxvarcharsize=254;maxlongvarcharsize=8190;debug=0;commlog=1;optimizer=1;ksqo=1;usedeclarefetch=0;textaslongvarchar=1;unknownsaslongvarchar=0;boolsaschar=0;parse=0;cancelasfreestmt=0;extrasystableprefixes=dd_;lfconversion=1;updatablecursors=0;disallowpremature=0;trueisminus1=0;bi=0;byteaaslongvarbinary=0;useserversideprepare=0;lowercaseidentifier=0";
cnDB.Open();


Cheers,

Patrick

----------------------------------------------------------------------

Comment By: Patrick Donelan (patspam)
Date: 2006-04-18 02:47

Message:
The new version works, nice work.

Patrick

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-04-16 02:56

Message:
Please replace the dll psqlodbc35w.dll by the one at
 http://www.geocities.jp/inocchichichi/psqlodbc/index.html  and retry.

regards,
Hiroshi Inoue

----------------------------------------------------------------------

Comment By: Patrick Donelan (patspam)
Date: 2006-04-14 02:49

Message:
Thanks Hiroshi. Please don't work over Easter! :)

Patrick

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-04-14 01:02

Message:
Oh I see.
I would provide a modified version.
Please wait for a day or so.

regards,
Hiroshi Inoue

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000611&group_id=1000125

pgsql-odbc by date:

Previous
From: "Russ Cobbe"
Date:
Subject: ODBC programmer needed
Next
From: "Jonathan Blitz"
Date:
Subject: PostgreSQL and Access - relink