I created a custom script source component to pull data from a dirty
pervasive 2000i DB service pack4.

Heres the problem my component will pull 425 rows of data but it will do
this only if I set my deffaultBufferMaxRows property to a small number like
17. It will not pull more than 425 it hang and pull no more and if I leave my
deffaultBufferMaxRows to the default value of 10000 it gives an error saying
that the 'the connection has been disabled" also if i only output some of the
columns it work fine getting all the data to completion.

The table I am importing has 140 columns 490233 rows and various data types.
The max number of columns I was able to pull without error was 132

Hello rhjDBA,

Could this be a Driver issue. What type of connection manager are you using
to connect to Pervasive?


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

That is a possibility the connection manager i am usig is ODBC

"Allan Mitchell" wrote: