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

Chris Seymour @ Simba ChrisS at simba.com
Thu Oct 18 17:46:13 BST 2007

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.

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.

More information about the unixODBC-support mailing list