[unixODBC-dev] Problem getting error on SQL_NO_DATA

Nick Gorham nick.gorham at easysoft.com
Fri Apr 8 15:27:09 BST 2005


Eric Sharkey wrote:

>>That should be a simple thing to do, to try, just edit 
>>DriverManager/__info.c and on or about line 4870 change
>>
>>    
>>
>[]
>  
>
>>     if ( ret_code == SQL_ERROR ||
>>             ret_code == SQL_SUCCESS_WITH_INFO )
>>     {
>>    
>>
>[]
>  
>
>>     if ( ret_code == SQL_ERROR ||
>>             ret_code == SQL_SUCCESS_WITH_INFO ||
>>	    ret_code == SQL_NO_DATA )
>>     {
>>    
>>
>
>I'm confused.  Why are you checking the return code at all?  I thought
>the only return code which would assure no diagnostic records was
>SQL_INVALID_HANDLE.  Although uncommon, a driver can return diagnostics
>even with SQL_SUCCESS, right?
>  
>
Not as far as I know, thats what the SQL_SUCCESS_WITH_INFO is used to 
signify. What point would there be to have that if it could return a 
warning with a SQL_SUCCESS. or for that matter a error diagnostic with a 
SQL_SUCCESS return.

-- 
Nick



More information about the unixODBC-dev mailing list