title: Alternatives to Linked server (the remote server is pervasive sql)
body: <p>We have spent in total around 50 hours trying to debug our linked server connection from sql server 2012 to pervasive sql.</p>
  
  <p>Needless to say, pervasive is the issue.</p>
  
  <p>We are ONLY running <code>select</code> queries like this:</p>
  
  <pre><code>select * from [sqlserver].[pervasiveserver].[db]..[myremotetable]
  </code></pre>
  
  <p>We are so frustrated with this, that I do not even want to discuss the errors that we are getting. Several experts said that it's probably related to a bad pervasive odbc driver.</p>
  
  <p>We have SSRS reports whose datasource points to the sql server. </p>
  
  <p><strong>Can you suggest an alternative method to linked servers in this case?</strong> Our main task is to be able to select from a pervasive database using SSRS?</p>