title: able to connect to linked server but i cannot select from any table
body: <p>I have a linked server to a pervasive sql 11 database from my sql server 2012 64bit using ODBC</p>
  
  <p>I am able to see the databases on this server, but when I select * from any table I am getting this error:</p>
  
  <pre><code>OLE DB provider "MSDASQL" for linked server "kslap208" returned message "[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)".
  OLE DB provider "MSDASQL" for linked server "kslap208" returned message "[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Unable to open table: aactual.".
  Msg 7306, Level 16, State 2, Line 1
  Cannot open the table ""sbxc003"."aactual"" from OLE DB provider "MSDASQL" for linked server "kslap208". 
  </code></pre>
  
  <p>How is it possible that I am able to test the connection succesfully and see all the databases; however, I cannot select?</p>