[unixODBC-support] cursor not supported in unixodbc?

Tom Lee tom_lee01 at hotmail.com
Thu Oct 28 22:36:32 BST 2004



>From: Nick Gorham <nick.gorham at easysoft.com>
>Reply-To: Support for the unixODBC project <unixodbc-support at easysoft.com>
>To: Support for the unixODBC project <unixodbc-support at easysoft.com>
>Subject: Re: [unixODBC-support] cursor not supported in unixodbc?
>Date: Thu, 28 Oct 2004 07:48:19 +0100
>
>Tom Lee wrote:
>
>>
>>Yes. I tried the latest version with MyODBC 3.5.1. The SQL Connect is OK 
>>now.
>>Thanks.
>>
>>However, it comes with another problem.
>>
>>I want to reuse hstmt handler, even after I run
>>SQLFreeStmt(hstmt, SQL_RESET_PARAMS);
>>I still cannot reuse hstmt. However, iODBC has no such a problem.
>
>Well, if there is a cursor open on that statement, then its right to fail, 
>you ould normally expect to need a free stmt with a SQL_CLOSE.

right.

>Send a ODBC trace and I will check.
>
>I would be supprised is the states checking is wrong, it may just be that 
>iODBC doesn't bother checking what it should. A trace will show whats going 
>on.

The old version of iodbc works fine, the latest release requires to close 
cursor first.
I need to modify my code.

thanks.

-T

>
>--
>Nick
>_______________________________________________
>unixODBC-support mailing list
>unixODBC-support at easysoft.com
>http://mail.easysoft.com/mailman/listinfo/unixodbc-support

_________________________________________________________________
Get ready for school! Find articles, homework help and more in the Back to 
School Guide! http://special.msn.com/network/04backtoschool.armx




More information about the unixODBC-support mailing list