Maximum size of a recordset

--Boundary_(ID_uByu4bbYXdYtWotK+ImAhg)
Content-type: text/plain; charset=ISO-8859-8-I; format=flowed
Content-transfer-encoding: 7BIT

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


--Boundary_(ID_uByu4bbYXdYtWotK+ImAhg)
Content-Type: text/plain; charset=us-ascii


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
--Boundary_(ID_uByu4bbYXdYtWotK+ImAhg)--

Re: Maximum size of a recordset

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.com

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