selecting more fields causes catastrophic failure
So you are using Microsoft OLE DB Provider for ODBC (MSDASQL) which is presumably pointing to the ODBC DSN for your Pervasive data source. Since the error is an Access Violation (AV), I'm willing to bet that the AV is raised due to something going wrong in the Pervasive ODBC driver. Since you also mention that this query works from some other machine, can you double check the:


ODBC DSN configuration between the 'bad' machine and the 'good' machine?
The ODBC driver version for Pervasive - is it the same on both 'good' and 'bad' machines?