0

In my source code I need to read the content of an Excel 2007 stylesheet. So, I first set up an OleDbConnection to it :

OleDbConnection conn = new OleDbConnection(String.Format(@"Provider = Microsoft.ACE.OLEDB.12.0;Data Source = {0};Extended Properties =""Excel 12.0 Xml;HDR=YES;IMEX=1"";", xlsFilePath));

This works perfectly on my computer, but not on the server once deployed : Microsoft.ACE.OLEDB.12.0 is not an available provider there. That's probably because I have Office 2007 on my computer. Unfortunately, I'm not allowed to install it on the server.

Yet I could probably install only the dll containing the provider on the server and that would be ok... as long as I'd be able to know what that damned dll is !

That's where I tear my hair out : I can't find my way in the debug window's members tree to find out the actual component which is dynamically loaded to deal with the Excel 12.0 connection : which class ? Which assembly ? No idea, I'm lost.

Your help will be greatly appreciated ! :-)

Ssithra
  • 710
  • 3
  • 8
  • 1
    Duplicate of http://stackoverflow.com/questions/238625/microsoft-ace-oledb-12-0-provider-is-not-registered? – Luke Girvin Jun 23 '11 at 09:18
  • Do you have to use ACE? Maybe your solution will work Jet (Microsoft.Jet.OLEDB.4.0) - it should be on your server preinstalled? (Which server are you using?) – Juliusz Jun 23 '11 at 11:20

1 Answers1

0

I eventually fixed my problem by installing the drivers for Office 2007 on the server (the Office 2007 drivers don't involve the same problems as the Office 2007 applications in terms of licenses).

Here is the link : http://www.microsoft.com/download/en/confirmation.aspx?id=23734

Then I modified my connectionstring to 

@"Provider = Microsoft.ACE.OLEDB.12.0;Data Source = {0};Extended Properties =""Excel 12.0 Xml;HDR=YES;IMEX=1"";"

Hope this will help someone facing the same questions. :-)

Ssithra
  • 710
  • 3
  • 8