title: catastrophic failure trying to select from linked server
body: <p>I have created a linked oledb/odbc connection to Pervasive SQL from SQL SERVER 2012:</p>
  
  <pre><code>USE [master]
  GO
  
  /****** Object:  LinkedServer [KSLAP208]    Script Date: 2/8/2013 10:38:55 AM ******/
  EXEC master.dbo.sp_addlinkedserver @server = N'KSLAP208', @srvproduct=N'Pervasive ODBC Interface', @provider=N'MSDASQL', @datasrc=N'C003', @location=N'localhost'
   /* For security reasons the linked server remote logins password is changed with ######## */
  EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'KSLAP208',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
  
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'collation compatible', @optvalue=N'false'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'data access', @optvalue=N'true'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'dist', @optvalue=N'false'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'pub', @optvalue=N'false'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'rpc', @optvalue=N'false'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'rpc out', @optvalue=N'false'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'sub', @optvalue=N'false'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'connect timeout', @optvalue=N'0'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'collation name', @optvalue=null
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'lazy schema validation', @optvalue=N'false'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'query timeout', @optvalue=N'0'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'use remote collation', @optvalue=N'true'
  GO
  
  EXEC master.dbo.sp_serveroption @server=N'KSLAP208', @optname=N'remote proc transaction promotion', @optvalue=N'true'
  GO
  </code></pre>
  
  <p>Test Connection is succesful.</p>
  
  <p>However, when I try to select from a database:</p>
  
  <pre><code>select * from [KSLAP208].[C003]..PA_Profile_BASE_1119 
  </code></pre>
  
  <p>I immdiately get just the field names returned and then immediately after that I get this error:</p>
  
  <pre><code>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".
  </code></pre>
  
  <p>What am I doing wrong? Why Can I not select? I am able to see all the databases and tables on the linnked server.</p>
  
  <p><strong>if I select a small amount of data select field1,field2 it works without problems.</strong></p>