title: Failed to find or load the registered .Net Framework Data Provider (VS2005)
body: <p>I am editing some existing code, and as part of the changes I need to add a column to each of two datasets (.xsd in Visual Studio Solution Explorer).</p>
  
  <p>One worked fine - open the designer, right-click, add column.</p>
  
  <p>The second gives the following error:</p>
  
  <p>"Failed to add column. Failed to find or load the registered .Net Framework Data Provider."</p>
  
  <p>As these are both in the same project, I'm confused as to why this one is failing when the other is not.</p>
  
  <p>The only difference I can think of, is that the one that works is selecting from the database directly (<code>SELECT ... FROM TABLENAME</code>); whereas the one that fails is selecting from a database function (<code>SELECT ... FROM dbo.FunctionName(@param) AS ALIASNAME</code>)</p>
  
  <p>Wherever I've looked, people suggest it's an error with the .settings / .config files; but because one works and one fails, I can't see how this can be an issue with references?</p>
  
  <p>This is in a standard vb project in VS2005, that compiles to a DLL - so it's not asp.net.</p>
  
  <p>--Edit--</p>
  
  <p>Right-click,  Preview Data also gives the same error.</p>
  
  <p>--Edit2--</p>
  
  <p>When I try and Add a DataSource, I get the following error:</p>
  
  <p><code>This SQL Server version (10.50) is not supported.</code></p>
  
  <p>I have SQL Server 2005, and SQL Server 2008 R2 installed, both with latest service packs.</p>