Error using openrowset

Navigation
0

I have a problem regarding openrowset .

I am running the following encoding: 

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
  'Excel 12.0;Database=C:\Procesos\PRUEBA.xlsx', [Hoja1$])

and I get the following error:

  

The OLE DB provider 'Microsoft.ACE.OLEDB.12.0' can not be used for distributed queries because it is configured to run in simple controlled threading mode.

    
asked by javier antonio cordova carpio 05.11.2016 в 00:44
source

1 answer

0

Apparently, before you must run the following sentences to allow your type of query. I hope it works for you: 

EXEC sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE;  
GO  
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;  
GO  
RECONFIGURE;  
GO
    
answered by 05.11.2016 в 00:51
Github + Netbeans + SourceTree ERROR in Push Error committing a project