Linq to Excel and publish to godaddy issue

Question

All works fine on my machine , but after publishing to godaddy, I got this error :

 [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() ,

Any idea how to make it work fine on the hosting server, also it's sharing host I mean I cannot setup any programs on it.

Error msg is very clear: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." — Mitch Wheat, May 28 '14 at 04:16
I know it's clear but am not sure what to do to solve it , am not asking about the meaning, am asking what can I do while I cannot setup any programs — AMH, May 28 '14 at 04:17
Then I think its not possible. There are lots of limitations in godaddy server. They do not provide Office interops in shared hosting. you better contact godaddy support. — Krishanu Dey, May 28 '14 at 04:21

score 1 · Answer 1 · answered May 28 '14 at 13:22

Like Krishanu Dey mentioned in the comments, you can't use LinqToExcel on GoDaddy's shared hosting because they won't let you install the required OleDb engine that LinqToExcel uses.

You'll want to look into getting a VPS to install the OleDeb engine.

score 0 · Accepted Answer · answered May 29 '14 at 11:52

0

I solved it using openxml SDK , a little bit slower but it do the task

answered May 29 '14 at 11:52

AMH

6,363
27
84
135

Linq to Excel and publish to godaddy issue

2 Answers2