Share via

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".

  • Article

Question

Thursday, May 9, 2013 11:38 AM

Hi,

i tried in sql server 2008 by executing this querry.

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=d:\test.xlsx','select * from [sheet1$]')

i got this error

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".

i tried giving permissions to temp folder but still i dn't help me.

Any one can help me in solving this issue ASAP.

Thanks,

Vindhya

All replies (5)

Thursday, May 9, 2013 11:54 AM ✅Answered

Hi,

try setting these settings... it may work...!

USE [master] 
GO

EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO
 
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1 
GO 
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1 
GO

Nagarjuna Dilip

Thursday, May 9, 2013 12:10 PM ✅Answered

ok... Then try these settings

  1. Open SQL Server Configuration Manager.
  2. Select the SQL Server Services folder in the left pane.
  3. Right-click the SQL Server (MSSQLSERVER) service in the right pane.
  4. Click Properties.
  5. Click the Advanced tab in the properties dialog that pops up.
  6. Add “-g512;” to the front of the value for parameter “Startup Parameters”.
  7. Click OK.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/83300532-e780-4ac6-9a64-7246e58c253a

It may work...!

Nagarjuna Dilip

Thursday, May 9, 2013 12:01 PM

Hi,

Thanks for your quick reply. I tried those settings but still i'm getting the same error.

Thursday, May 9, 2013 12:17 PM

Thanks alot! it worked. But, what is -g512 is used for?

Thursday, May 9, 2013 12:22 PM

Please refer to above link which i posted. Take look  @Nathon Dalton's reply :)

Nagarjuna Dilip