Hello
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.
SdacDemo/ChangeNotification:
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.
{5CF4CA11-EF21-11D0-97E7-00C04FC2AD98}
[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?
Regards
Peter Grahm