locked
linqtoExcel and publish to godaddy issue RRS feed

  • 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 works fine on the hosting server , also it's sharing host I mean I cannot setup any programs on it

    Wednesday, May 28, 2014 4:18 AM

Answers

  • I solved using openxml sdk it works fine
    • Marked as answer by Anne Jing Wednesday, June 4, 2014 6:58 AM
    Thursday, May 29, 2014 9:08 AM

All replies

  • Hi,

    Godaddy, As per my knowledge, they won't install 'Microsoft.ACE.OLEDB.12.0' , they do as little as possible for their paying public.

    The problem is its a limitation being imposed by godaddy itself: (http://support.godaddy.com/groups/web-hosting/forum/topic/using-excel-spreadsheets-on-website/)

    Also, you can transform your data into database table SQL/MS Access instead of Excel.

    I would recommend getting in touch with whoever runs your web hosting task if they would install the oledb 12 driver for you.

    Hope, this will help you out. Feel free to ask if you have any query.


    If this post answers your question, please click Mark As Answer. If this post is helpful please click Mark as Helpful.

    • Proposed as answer by Tejas T Thursday, May 29, 2014 3:32 AM
    Wednesday, May 28, 2014 7:08 AM
  • I solved using openxml sdk it works fine
    • Marked as answer by Anne Jing Wednesday, June 4, 2014 6:58 AM
    Thursday, May 29, 2014 9:08 AM