Friday, November 25, 2011 3:13 AM
Went I Used Microsoft.ACE.OLEDB.12.0 to export Excel from sql on local it success but went i do it from other server it's error Ad hoc access to OLE DB provider 'Microsoft.ACE.OLEDB.12.0' has been denied. You must access this provider through a linked server
Who can help me!
Friday, November 25, 2011 5:20 PM
An Stupid problem that i have already soffered a lot, try to execute your SQL Server management studio as administrator and execute the same query, probably it will conclude with sucess.
Fabrizzio A. Caputo
Oracle OCA 11g
MCITP SQL Server 2008 Implementation and Maintenance
MCITP SQL Server 2008 Developer
Blog Pessoal: www.fabrizziocaputo.wordpress.com
Blog Empresa: www.tripletech.com.br/blog
Saturday, November 26, 2011 7:08 AMModeratorYou have to enable Ad Hoc access on the other server, check out this article => http://www.kodyaz.com/articles/enable-Ad-Hoc-Distributed-Queries.aspx