Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it.
When I do
select * or
select field1,field2,field3....field15 I am getting this error:
Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "KSLAP208" reported an error. The provider reported an unexpected catastrophic failure. Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "KSLAP208".
I feel like there is some kind of memory issue? It will not allow me to select more than a certain amount of data?
whereas if I select a small amount of data
select field1,field2 it works without problems.
What am I doing wrong?