Error with SdacDemo/ChangeNotification to remote server.

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 5
Joined: Tue 22 Jul 2008 10:36

Error with SdacDemo/ChangeNotification to remote server.

Post by SpeedyC » Thu 24 Jul 2008 11:30


I had a problem with query notification in my application so I tested the SdacDemo and got the same problem.

Everything works fine when running on the same PC as the SQL server(MS SQL Server Express Edition 9.00.3042.00) runs but when trying to run from another PC i run into problems.

Opening connection 2 works fine but when opening connection 1 I get the following error(translated from swedish).

A multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
[0] := $1. PropId := 18
[1] := $1. PropId := 17
[2] := $1. PropId := 19

I've tried making changes to db as noted in your help about ANSI_NULLS ON and the rest but can't get it work.

Also tried Trustworthy On, permission changes and logging in as SA and other user but the get the same result.

Any hints on what could be going on here?

Peter Grahm

Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Fri 25 Jul 2008 06:39

This feature requires SQL Native Client to be installed on client computers. Make sure that it is installed. If does not, download it by this link.

Post Reply