Error when connecting TMSQuery to TMSChangeNotification

eh · Post by eh » Sun 02 Jan 2011 12:55

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 ?

eh · Post by eh » Mon 03 Jan 2011 20:00

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.

AndreyZ · Post by **AndreyZ** » Tue 04 Jan 2011 08:23

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