.NET
Microsoft Technologies based on the .NET software framework.
3,415 questions
ACE.OLEDB.12.0 Clashes my app sometimes when executed.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 2%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hiago Souza
1
Reputation point
I have been using OLEDB with an RPA tool(BluePrism) and sometimes causes a Exception that makes the app to clash. Checking the Event Viewer, I´ve found this exeception:
Application: Automate.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
at System.Data.OleDb.DataSourceWrapper.InitializeAndCreateSession(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.SessionWrapper ByRef)
at System.Data.OleDb.OleDbConnectionInternal..ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, System.Object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, System.Object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection, System.Data.Common.DbConnectionOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionPoolGroup, System.Data.Common.DbConnectionOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(System.Data.Common.DbConnection, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal, System.Data.ProviderBase.DbConnectionInternal ByRef)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Data___OLEDB_Extended.Open(System.String)
Exception Info: System.Reflection.TargetInvocationException
at System.RuntimeMethodHandle.InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(System.Object, System.Object[], System.Object[])
at System.Reflection.RuntimeMethodInfo.Invoke(System.Object, System.Reflection.BindingFlags, System.Reflection.Binder, System.Object[], System.Globalization.CultureInfo)
at BluePrism.AutomateProcessCore.Compilation.MethodInvoker.InvokeMethod(System.Object, System.String, BluePrism.AutomateProcessCore.Argument[], BluePrism.AutomateProcessCore.Argument[])
at BluePrism.AutomateProcessCore.CompilerRunner.Execute(BluePrism.AutomateProcessCore.Stages.CodeStage, BluePrism.AutomateProcessCore.ArgumentList, BluePrism.AutomateProcessCore.ArgumentList, System.String ByRef)
at BluePrism.AutomateProcessCore.Stages.CodeStage.Execute(System.Guid ByRef, BluePrism.AutomateProcessCore.CompoundLoggingEngine)
at BluePrism.AutomateProcessCore.BluePrismProcess.r(BluePrism.AutomateProcessCore.ProcessBreakpointInfo ByRef, Boolean)
at BluePrism.AutomateProcessCore.BluePrismProcess.RunAction(BluePrism.AutomateProcessCore.Processes.ProcessRunAction, BluePrism.AutomateProcessCore.ProcessBreakpointInfo ByRef, Boolean)
at BluePrism.AutomateProcessCore.BluePrismProcess.RunAction(BluePrism.AutomateProcessCore.Processes.ProcessRunAction)
at BluePrism.AutomateProcessCore.VBO.DoDoAction(System.String, BluePrism.AutomateProcessCore.ProcessStage, BluePrism.AutomateProcessCore.ArgumentList, BluePrism.AutomateProcessCore.ArgumentList ByRef)
at BluePrism.AutomateProcessCore.BusinessObject.DoAction(System.String, BluePrism.AutomateProcessCore.ProcessStage, BluePrism.AutomateProcessCore.ArgumentList, BluePrism.AutomateProcessCore.ArgumentList ByRef)
at BluePrism.AutomateProcessCore.Stages.ActionStage.Execute(System.Guid ByRef, BluePrism.AutomateProcessCore.CompoundLoggingEngine)
at BluePrism.AutomateProcessCore.BluePrismProcess.r(BluePrism.AutomateProcessCore.ProcessBreakpointInfo ByRef, Boolean)
at BluePrism.AutomateProcessCore.BluePrismProcess.RunAction(BluePrism.AutomateProcessCore.Processes.ProcessRunAction, BluePrism.AutomateProcessCore.ProcessBreakpointInfo ByRef, Boolean)
at AutomateUI.ctlProcessViewer.ExecuteAction(BluePrism.AutomateProcessCore.Processes.ProcessRunAction)
at AutomateUI.ctlProcessViewer.DebugAction(BluePrism.AutomateProcessCore.Processes.ProcessRunAction, Boolean)
at AutomateUI.frmProcess.evhDoStepOver(System.Object, System.EventArgs)
at System.Windows.Forms.ToolStripItem.RaiseEvent(System.Object, System.EventArgs)
at System.Windows.Forms.ToolStripButton.OnClick(System.EventArgs)
at System.Windows.Forms.ToolStripItem.HandleClick(System.EventArgs)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(System.Windows.Forms.MouseEventArgs)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(System.EventArgs, System.Windows.Forms.ToolStripItemEventType)
at System.Windows.Forms.ToolStripItem.FireEvent(System.EventArgs, System.Windows.Forms.ToolStripItemEventType)
at System.Windows.Forms.ToolStrip.OnMouseUp(System.Windows.Forms.MouseEventArgs)
at System.Windows.Forms.Control.WmMouseUp(System.Windows.Forms.Message ByRef, System.Windows.Forms.MouseButtons, Int32)
at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.ToolStrip.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG ByRef)
at System.Windows.Forms.Application+ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr, Int32, Int32)
at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Int32, System.Windows.Forms.ApplicationContext)
at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Int32, System.Windows.Forms.ApplicationContext)
at System.Windows.Forms.Application.RunDialog(System.Windows.Forms.Form)
at System.Windows.Forms.Form.ShowDialog(System.Windows.Forms.IWin32Window)
at System.Windows.Forms.Form.ShowDialog()
at AutomateUI.BPApplication.Start(System.String[])
at Automate.Program.Main(System.String[])
I am using the Microsoft Access Database Engine 2016 Redistributable 32 bit version.
.NET
{count} votes
-
Viorel 112.5K Reputation points2022-11-16T10:03:20.803+00:00 Are you sharing the database file between different threads or instances of your applications?
-
Hiago Souza 1 Reputation point
2022-11-16T13:04:32.793+00:00 It is using just one instance.
-
Jack J Jun 24,296 Reputation points Microsoft Vendor2022-11-22T02:00:25.217+00:00 @Hiago Souza , Welcome to Microsoft Q&A, how do you use the OLEDB with an RPA tool? Do you have some code about it? If so, please share it with me.
-
Hiago Souza 1 Reputation point
2022-11-22T02:37:57.003+00:00 This Is the code to open the connection:
If moConnection Is Nothing Then moConnection = New OLEDBConnection(ConnectionString) moConnection.Open() End IfConnectionString = Provider=Microsoft.ACE.OLEDB.12.0; Data Source="\Folder\File.xlsx";Extended Properties="Excel 12.0 Xml;HDR=NO;"
It works, but sometimes it gives me error.
-
Jack J Jun 24,296 Reputation points Microsoft Vendor
2022-11-22T07:07:41.817+00:00 @Hiago Souza , Do you mean that you meet the error that Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine? If so, you could Right-click your project->Go to project properties->Build tab->Platform target, then change between x86 , x64 and AnyCPU validate your selection and run debug to test.
-
Hiago Souza 1 Reputation point
2022-11-22T12:58:14.597+00:00 In this case, is a System.AccessViolationException.
-
Jack J Jun 24,296 Reputation points Microsoft Vendor
2022-11-23T06:56:28.887+00:00 @Hiago Souza , which platform causes the exception? I used x64, it works well for me.
-
Hiago Souza 1 Reputation point
2022-11-23T17:23:05.633+00:00 I am using the Microsoft Access Database Engine 2016 Redistributable 32 bit version.
-
Jack J Jun 24,296 Reputation points Microsoft Vendor
2022-11-24T02:57:05.203+00:00 @Hiago Souza , thanks for response, what I mean is that I changed app Platform target to x64 instead of the version of Microsoft Access Database Engine 2016.
-
Hiago Souza 1 Reputation point
2022-11-24T14:54:51.22+00:00 At its core, the app runs as a 32-bit application.
-
Jack J Jun 24,296 Reputation points Microsoft Vendor
2022-11-29T02:10:50.087+00:00 @Hiago Souza , Sorry for the late response, I did many searches about your problem.
The common two answer are changing platform or install the Microsoft Access Database Engine 2016 Redistributable.
Now, I recommend that you could check what is happened in your event viewer when you meet the error again.
Sign in to comment