[ psqlodbc-Bugs-1000611 ] Empty exception thrown when no password supplied

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=10006 11&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 specifying a password in the connection string.

I am submitting this as a bug because the non-experimental psqlodbc branch would throw an ODBCException with an exception message 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=54 32;sslmode=prefer;uid=myuid;readonly=0;protocol=6.4;fakeoidi ndex=0;showoidcolumn=0;rowversioning=0;showsystemtables=0;fe tch=100;socket=8192;unknownsizes=0;maxvarcharsize=254;maxlon gvarcharsize=8190;debug=0;commlog=1;optimizer=1;ksqo=1;usede clarefetch=0;textaslongvarchar=1;unknownsaslongvarchar=0;boo lsaschar=0;parse=0;cancelasfreestmt=0;extrasystableprefixes= dd_;lfconversion=1;updatablecursors=0;disallowpremature=0;tr ueisminus1=0;bi=0;byteaaslongvarbinary=0;useserversideprepar e=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=10006 11&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend