Devart Forums

Hello

I have problem with query notification in my application. I have started two (or more) instances of the application, which both modify data and is tracking for changes i data (like connection 2 and connection 1 in sdacDemo). Lets call them instance A and B. If I close instance B, I immediately get an error message in instance A: "invalid object name 'SDAC_NS_58_QUEUE'", where the number 58 differs from time to time. When I close instance A i get the error message: "Cannot drop the service 'SDAC_NS_58', because it does not exist or you do not have permission.", and then anothor: "Assertion failure (D:\Projects\Delphi\Sdac\MSAccess.pas, line 2912)", where D:\Projects\Delphi\Sdac\Source is where i keep my source code for sdac on my developing machine.

Seems to work when I give the user a server role as either 'processadmin', 'serveradmin' or 'sysadmin'. Is there a way to configure the user without one of these server roles? Is it an bug in SDAC that requieres the user to be in one of these server roles?

Using Delphi 7 with SDAC 4.50.0.39

Think we found the source of the problem. It has to do with permissions and as we don't want our program to access with a login that has serverrole as sysadmin (like sa) we have created our own login, user and schema. The login has membership in DB_OWNER but that doesnt seem to be enough. DB_OWNER gives us all permissons for database available, right? Any advice on what permissions needed to get notifications working? Is there any server permissons we need?

What happens when we have not got enough permissions is that when we close an instance (while having another one ore more instances still running) it drops all the instances queue objects found in sys.service_queues.

Regards
Peter Grahm

Hello

I have problem with query notification in my application. I have started two (or more) instances of the application, which both modify data and is tracking for changes i data (like connection 2 and connection 1 in sdacDemo). Lets call them instance A and B. If I close instance B, I immediately get an error message in instance A: "invalid object name 'SDAC_NS_58_QUEUE'", where the number 58 differs from time to time. When I close instance A i get the error message: "Cannot drop the service 'SDAC_NS_58', because it does not exist or you do not have permission.", and then anothor: "Assertion failure (D:\Projects\Delphi\Sdac\MSAccess.pas, line 2912)".
I do not get the error described above when i run my application on my developing machine. I do not get the error described above when i run two instances of sdacDemo.

Regards
Peter Grahm

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

Hello

Trying to convert an application that currently using ADO components to SDAC, I encounter problems on that we have a third party component that returns an ADO recordset and I directly load it into a TADOQuery like:

ADOQuery1.Recordset:=ReturnedRecordset;

My idea was that you could use the TVirtualTable instead but the help is a bit vague to me at least.

TVirtualTable.LoadFromFile states that it can load a XML document in ADO compatible format. Is there any example on doing this?

There will also be an upcoming task for me to transfer data returned from a Query to a ADO recordset in the third party component stated previously.

I would greatly appreciate any information on converting ADO recordsets SDAC.

Regards
Peter Grahm