• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1321
  • Last Modified:

Microsoft.Ace.OLEDB.12.0

Hi,

I am running Windows Server 2003.  I have SQL Server 2005 installed and I have Access 2007 installed.

I have two SQL stored procedures to import excel files into SQL tables.  The one that imports files with the older .xls extension use the Access JET provider.  That sp is working just fine.  The other sp for importing the newer .xlsx files fails.  The ASP.NET executing the sp returns:  Ad hoc access to ole db provider.... bla bla bla.  

I had the same problem with using JET.  I just had to go to the registry and navigate to HKLM\software\microsoft\microsoft sql server\mssql.1\providers\microsoft.jet.oledb.4.o and create a key called Disallowadhocaccess.

HOWEVER, I don't have any registry path under sql server that has a key named like Microsoft.Ace.  That makes me think that I don't have that provider installed (even though office 2007 installed).  

Can anyone tell me ... do I need to download and install that provider or should I just make a registry path?  Note that under sql server I have MSSQL.1 through MSSQL.5.
0
santaspores1
Asked:
santaspores1
3 Solutions
 
santaspores1Author Commented:
I don't have any registry path that leads to \providers\Microsoft.Ace.OLEDB.12.0
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
santaspores1Author Commented:
http://www.kodyaz.com/articles/enable-Ad-Hoc-Distributed-Queries.aspx
and
http://www.appsecinc.com/resources/top10-database-security-issues/Large-Attack-surface-etc/c-OLEDB-ad-hoc-queries-allowed.shtml

Thanks you guys.  

This isn't the issue though.  Please ignore the "Ad hoc access to ole db provider..." message.  The problem is that I do not seem to have the ACE provider installed.  And I am referencing that provider when importing xlsx documents.  NOTE that everything works just fine when I use the JET provider... but I also need to be able to use the ACE provider.
0
 
CodeCruiserCommented:
0
 
santaspores1Author Commented:
Thank you for your help.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now