Microsoft ACE DatabaseEngine 2010 driver (12.0) problem, after Windows 10 1909 Cumulative Updates (and later) is installed

  • Thread starter Thread starter woch
  • Start date Start date
W

woch

Guest
Hello,<svg aria-hidden="true" class="mln2 mr0 svg-icon iconHistory" height="18" viewBox="0 0 19 18" width="19"></svg>
since cumulative Windows 10 1909 updates are installed, I get following exception when accessing MS Access accdb. :
External component has thrown an exception?
After reinstalling Microsoft ACE DatabaseEngine 2010 (OLEDB.12.0 ..), all works fine again.
What can I do about it?

'.....
Dim sel As String = "Select Notiz from T_TerminNotiz where ztrText=@ztrText and serNr=@serNr"
Using myConnection As New OleDbConnection(myConnStringX1)
myConnection.Open()

Using mySqlCmd As New OleDbCommand(sel, myConnection)
mySqlCmd.CommandType = CommandType.Text
mySqlCmd.CommandTimeout = myCmdTimeOut
mySqlCmd.CommandText = sel
mySqlCmd.Parameters.Clear()
mySqlCmd.Parameters.Add(New OleDbParameter("@ztrText", OleDbType.VarChar)).Value = strKlient
mySqlCmd.Parameters.Add(New OleDbParameter("@serNr", OleDbType.Integer)).Value = serNr
oRet = mySqlCmd.ExecuteScalar()
End Using

End Using
'....

Continue reading...
 
Back
Top