I' m using a Windows Forms application to export data to excel.
Application is built both x64 and x86.
So both version of Microsoft Access Databse Engine must be installed to work the application on same computer.
Firstly AccessDatabaseEngine.exe is installed
and AccessDatabaseEngine_x64.exe is installed passive.
x64 version of application is working
But x86 version is getting
SEHException: "External component has thrown an exception."
at System.Data.Common.UnsafeNativeMethods.IDBInitializeInitialize.Invoke(IntPtr pThis)
at System.Data.OleDb.DataSourceWrapper.InitializeAndCreateSession(OleDbConnectionString constr, SessionWrapper& sessionWrapper)
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()
The code part is below;
var accessConnection = new OleDbConnection(connectionString);
accessConnection.Open();
And ConnectionString is
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:UsersMeDesktopExportTest.xls";Extended Properties="Excel 8.0;HDR=Yes";
How can I solve it?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…