locked
Microsoft.ACE.OLEDB.12.0: Error.... RRS feed

  • Question

  • We have a server with windows standard OS 32 bit installed with 3.5 .Net framework and IIS 7.0

    We have also installed AccessDatabaseEngine.exe on the server.

    We used Connection string as "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Imports\Inputfile.xlsx;Extended Properties=Excel 12.0;HDR=Yes;IMEX=2" to read XLS and XLSX file.

    After all this, still we get following error: "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 epmo.frmImport.CreateDataSource(String sSystemFilePath)"

    Kindly advice!

     

    Regards,
    Ganesh

     


    Tuesday, September 6, 2011 9:10 AM

Answers