title: SQL Server and Microsoft.ACE.OLEDB.12.0
body: <p>I am getting the following: </p>
  
  <p>Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".</p>
  
  <p>When I execute the following from a Stored Procedure in SQLServer - </p>
  
  <pre><code>SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=c:\Users\v-bimoss\Source\Workspaces\External\Onesite\URLoadDB\Templates\T1-Current.xlsx', 'SELECT * FROM [Sheet1$]')
  </code></pre>
  
  <p>I have been through all the threads I could find on this topic - but still am having the problem</p>
  
  <p>I have verified that:</p>
  
  <ol>
  <li><p>The 64 bit Microsoft.ACE.OLEDB.12.0 drivers are loaded</p></li>
  <li><p>Ad Hoc Distributed Queries is set to 1</p></li>
  <li><p>Dynamic Parameter and Allow Inprocess are both set to 1</p></li>
  <li><p>Changed MSSQL to run under my account</p></li>
  <li><p>The account that is running MSSQL and the account I am using both have full access to <code>C:\Windows\ServiceProfiles\LocalService\AppData\Local\Temp</code></p></li>
  </ol>
  
  <p>Any help would be appreciated. -wmm</p>