Maximum size of a recordset

View: New views
2 Messages — Rating Filter:   Alert me  

Maximum size of a recordset

by Reuven Nisser-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,
Is there a limit to the size of a recordset connected via ODBC?
I have a table with 160,000 records which I need to pass one by one
(slow upgrade).
I opened a recordset using C++ CRecordset class and was able to receive
11000 records before getting an error of ODBC error 100 SQL_NO_DATA.
Thanks, Reuven



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=lists@...

Re: Maximum size of a recordset

by Jess Balint-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Reuven -

I don't know offhand what could cause this. What options are you using
on the data source? Also, what type of cursor are you using?

If you have a chance, please try creating an ODBC Trace log, and we can
take a look to try and reproduce the problem.

Jess

On Fri, Mar 07, 2008 at 10:30:24PM +0200, Reuven Nisser wrote:
> Hello,
> Is there a limit to the size of a recordset connected via ODBC?
> I have a table with 160,000 records which I need to pass one by one
> (slow upgrade).
> I opened a recordset using C++ CRecordset class and was able to receive
> 11000 records before getting an error of ODBC error 100 SQL_NO_DATA.
> Thanks, Reuven
>

>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:    http://lists.mysql.com/myodbc?unsub=jbalint@...

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=lists@...

LightInTheBox - Buy quality products at wholesale price!