Re: Problem retrieveing results from a query with an IMAGE field

"James K. Lowden" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Daniel A. Veiga wrote:
>    I can reproduce the problem systematically:
>      - If no row has any data in the IMAGE field -> no problem
>      - When a field has something in the blob column I get an error
> when trying to close the cursor (Linux Driver Manager log follows)
> 
> [ODBC][32484][SQLFreeStmt.c][140]
>                 Entry:
>                         Statement = 0x750380
>                         Option = 0
> [ODBC][32484][SQLFreeStmt.c][246]
>                 Exit:[SQL_ERROR]

Please post a TDSDUMP log of the session. 

>        If I try to call SQLGetDiagRec to get extended information, the
> result is SQL_NO_DATA (strange, should report something if the
> previous function returned SQL_ERROR or SQL_SUCCESS_WITH_INFO)

There are places in the ODBC code where diagnostic messages should be
produced but aren't.  You may have found one.  

HTH.  

--jkl
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.