Error when connecting TMSQuery to TMSChangeNotification

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
eh
Posts: 5
Joined: Sun 02 Jan 2011 12:29
Location: BEL
Contact:

Error when connecting TMSQuery to TMSChangeNotification

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
Posts: 5
Joined: Sun 02 Jan 2011 12:29
Location: BEL
Contact:

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.

Post Reply