title: The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
body: <p>I'm trying to run the following statement but am receiving the error messages just below.  I have researched answers to no end and none have worked for me.  I'm running Office 365 (64bit).  I have loaded the Microsoft Access Database Engine (64bit).  This is in Visual Studio 2013 with SSDT as well as SQL Server 2012.  I do not have access to changing environment or startup parameters to SQL Server.  Any help is appreciated.</p>
  
  <pre><code>SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.15.0', 
      'Excel 12.0;Database=C:\Users\UserName\Folder\SomeFile.xlsx;;HDR=NO;IMEX=1', [Table 1$])
  </code></pre>
  
  <ul>
  <li>Msg 7399, Level 16, State 1, Line 1 The OLE DB provider
  "Microsoft.ACE.OLEDB.15.0" for linked server "(null)" reported an
  error. The provider did not give any information about the error.</li>
  <li>Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source
  object of OLE DB provider "Microsoft.ACE.OLEDB.15.0" for linked
  server "(null)".</li>
  </ul>
  
  <p>Here's what I have tried:</p>
  
  <p>First, I ran...</p>
  
  <pre><code>sp_configure 'show advanced options', 1;
  RECONFIGURE;
  GO
  sp_configure 'Ad Hoc Distributed Queries', 1;
  RECONFIGURE;
  GO
  </code></pre>
  
  <p>Followed by...with no love.</p>
  
  <pre><code>EXEC sys.sp_addsrvrolemember @loginame = N'&lt;&lt;Domain\User&gt;&gt;', @rolename = N'sysadmin';
  GO
  
  EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.15.0', N'AllowInProcess', 1 
  GO 
  EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.15.0', N'DynamicParameters', 1 
  GO 
  </code></pre>
  
  <p>I have changed the code to read <strong>Microsoft.ACE.OLEDB.12.0</strong> as I have seen that as well, still no love.</p>
  
  <p>I have also checked permissions of C:\Users\MSSQLSERVER\AppData\Local\Temp and C:Windows\ServiceProfiles\NetworkService\AppData\Local which have granted Full Control for the following: System, MSSQLSERVER, and Administrators, Network Service (on the latter).</p>
  
  <p>Still no love.</p>
  
  <p>Lastly, I have tried changing to the 32bit version of the Microsoft Access Database Engine which has persisted in not working.</p>
  
  <p>Help, anyone?</p>