.Net Run time Error

May 25, 2010 at 11:44 PM


I have read about your product amd in the process of evaluating as I have lots of sharepoint sites that this exel/sharepoitn tool would be useful in. However, I tried version 1.2 and receive the "Format Inccorect" error. I

worked through most of the solutions provided in your discussion and found not of them provided an answer for me. So I have now uninstalled 1.2 and have installed 1.5. At the same point when I press upload I get the

.net following runtime error 

System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at ASP._layouts_spreadsheet_spreadsheet_aspx.GetExcelSheetNames() at ASP._layouts_spreadsheet_spreadsheet_aspx.btnUpload_Click(Object sender, EventArgs e)

I have installed the the 2007 office Drivers (which I was not sure if they should be installed on the client or the sharepoint server. Non the less I installed on both.

can you assist?