santaspores1
asked on
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\mi crosoft sql server\mssql.1\providers\m icrosoft.j et.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.
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\mi
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your help.
ASKER