[unixODBC-support] Unix ODBC ignores errors postedby SQLBrowseConnect with SQL_NEED_DATA

Chris Seymour @ Simba ChrisS at simba.com
Mon Oct 22 17:27:30 BST 2007

Thank you Nick 

Chris Seymour | Computer Scientist | Simba Technologies Inc.
Email: chriss at simba.com
Tel +1.604.633.0008 ext. 230 | Fax +1.604.633.0004

1090 Homer Street, Suite 200 | Vancouver, BC | Canada | V6B 2W9
Your Competitive Advantage for Data Connectivity Solutions

This email message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure, or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply email and
destroy all copies of the original message.  Thank you.

-----Original Message-----
From: unixodbc-support-bounces at easysoft.com
[mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of Nick Gorham
Sent: October 19, 2007 3:55 AM
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] Unix ODBC ignores errors postedby
SQLBrowseConnect with SQL_NEED_DATA

Chris Seymour @ Simba wrote:

>The spec: http://msdn2.microsoft.com/en-us/library//ms714565.aspx
>"SQLBrowseConnect also returns SQL_NEED_DATA if there are recoverable, 
>nonfatal errors during the browse process; for example, an invalid 
>password or attribute keyword supplied by the application. When 
>SQL_NEED_DATA is returned and the browse result connection string is 
>unchanged, an error has occurred and the application can call 
>SQLGetDiagRec to return the SQLSTATE for browse-time errors. This 
>permits the application to correct the attribute and continue the 
>I post a 28000 (authentication failure) error in my driver during
>SQLBrowseConnect() when someone gives bad authentication credentials, 
>and return SQL_NEED_DATA so they don't have to start the whole
>SQLBrowseConnect() process over again (as detailed in the quoted part 
>of the spec). However, it seems like UnixODBC is completely ignoring 
>the error I've posted and isn't returning it to the app.
The 2.2.13pre on the ftp site now should address this.

Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

unixODBC-support mailing list
unixODBC-support at easysoft.com

More information about the unixODBC-support mailing list