Linq到Excel并发布到godaddy问题

Question

在我的机器上，所有的操作都很好，但是在发布给godaddy之后，我得到了以下错误：

 [5/28/2014 3:54:41 AM ]: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. , System.Data ,   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, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at LinqToExcel.Query.ExcelUtilities.GetWorksheetNames(ExcelQueryArgs args)
   at LinqToExcel.Query.ExcelQueryExecutor.GetWorksheetName()
   at LinqToExcel.Query.ExcelQueryExecutor..ctor(ExcelQueryArgs args)
   at LinqToExcel.Query.ExcelQueryable`1..ctor(ExcelQueryArgs args)
   at LinqToExcel.ExcelQueryFactory.Worksheet(Int32 worksheetIndex)
   at ArabicEWorld.BusinessLayer.NounManager.processNounFile(String path)
   at ArabicEWorld.WebService.ArabicEWorldWebService.ProcessNounsFile() , 

任何知道如何使它在主机上正常工作，它也是共享主机--我的意思是我不能在它上设置任何程序。

Answer 1

我使用openxml SDK解决了这个问题，速度稍微慢了一点，但它完成了任务。

Answer 2

就像评论中提到的Krishanu一样，您不能在GoDaddy的共享主机上使用LinqToExcel，因为它们不允许您安装LinqToExcel使用的所需的OleDb引擎。

您需要了解如何获得一个VPS来安装OleDeb引擎。