Devart Forums

Hello,

I have a TMSQuery component I want to update with SQL notifications.

So I dropped a TMSChangeNotification component on the form and connected it with the TMSQuery (ChangeNotification).

When I make the TMSQuery active I get a OLE-DB error message :

• An error occurred in a OLE DB operation consisting of more than one step. Check all OLE DB status values, if available. No changes have been made.
  {5CF4CA11-EF21-11D0-97E7-00C04FC2AD98}
  [0] := $1. PropId := 18
  [1] := $1. PropId := 17
  [2] := $1. PropId := 19

Any idea what can be the cause of this ?

I already figured out how to solve the problem.

It appeared that the connection provider was set to 'prSQL'. Changing this to 'prNativeClient' solved the problem.

It is good to see that this problem was solved. If any other questions come up, please contact us.