i got a real weird problem. i've created a stored procedure in pervasive.sql 2000i which returns 15 records. when i call the stored procedure from asp.net (Command.ExecuteReader) i get only the first row.
i've also created another sp which returns, running from pervasive control panel, 439 records. i use this sp as datasource for a crystal report, except in this case it returns over 20.000 records till it crashes.
i'm using odbc pervasive client interface 22.214.171.124.
First off, get the SP4 and the HotFixes from the Pervasive web site. I know that SP3 was never tested or really supported with .NET.
As far as the Crystal Report, if you use the SQL statement rather than the SP, does it work?
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.