title: SQL Server 2012 - Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" (Microsoft SQL Server, Error: 7302)
body: <p>I just installed SQL Server 2012 to test differences and make sure it is ok for my Work.  I may not be a pro at SQL, but I don't see how to add a Link to Jet database on my server.  I have imported Jet Databases, but when going thru the GUI to Link a JET Database I see no Provider for JET.  I am running Access 2003 (I don't like the 2008+ GUI)</p>
  
  <p>I searched an found nothing simular to my issue; at least nothing I understood.  Nothing mentioned how to add Jet db Provider.</p>
  
  <p>I ran a connection string to the Jet Database thru QA:</p>
  
  <pre><code>sp_addlinkedserver 'USGEScrub', 'Access', 'Microsoft.Jet.OLEDB.4.0', 
  'D:\Lead$\SupList\USGEScrub.mdb'
  </code></pre>
  
  <p>The connection string works till I try to access the data and then I get this the errorand of course if I click the links nothing shows up:</p>
  
  <pre><code>TITLE: Microsoft SQL Server Management Studio
  Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
  </code></pre>
  
  <p>For help, click: <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&amp;LinkId=20476" rel="nofollow">http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&amp;LinkId=20476</a></p>
  
  <pre><code>ADDITIONAL INFORMATION:
  An exception occurred while executing a Transact-SQL statement or batch.
  Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked
  server "USGEScrub". (Microsoft SQL Server, Error: 7302)
  </code></pre>
  
  <p>For help, click: <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&amp;ProdVer=11.00.2100&amp;EvtSrc=MSSQLServer&amp;EvtID=7302&amp;LinkId=20476" rel="nofollow">http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&amp;ProdVer=11.00.2100&amp;EvtSrc=MSSQLServer&amp;EvtID=7302&amp;LinkId=20476</a></p>