Invalid object name ’SDAC_NS_58_QUUE’

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tpo
Posts: 3
Joined: Fri 13 Nov 2009 00:48

Invalid object name ’SDAC_NS_58_QUUE’

Post by tpo » Fri 13 Nov 2009 01:16

Problem with TMSChangeNotification

My "setup":

MSQuery1
MSQuery1.ChangeNotification:=MSChangeNotification1
MSQuery1.Options.ReflectChangeNotify:= true
MSQuery1.SQL:=
Select
TaskID,
Convert(NVARCHAR(10), Dato, 105) AS Dato,
DebitorNr,
DebitorNavn,
BrugerPC,
UserName,
UserFullName,
Locked,
LockedPC,
LockedBrugerLogon,
LockedBrugerNavn,
Status
From dbo.Task
Where UserName In (&UserName)
And Status In (&Status)
Order By UserName

My program is running on multible computers.
When I change macro in MSQuery1 on one PC
I some times get this error "Invalid object name ’SDAC_NS_58_QUUE’" or this "Exception EMSError in module MyProgram.exe at 00112BF. Cannot drop the service ‘SDAC_NS_58’, because it does not exist or you do not have permission."
All users have DBOwner rigths.

It most often hapens when the selection on one PC delivers no result, and another PC make a change, that afects the first computer's result.

Sory for my bad englich. I hope you can help
:-)

tpo
Posts: 3
Joined: Fri 13 Nov 2009 00:48

Please help

Post by tpo » Tue 17 Nov 2009 16:32

The problem seems to occur when a client is connected through a VPN Connection.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 18 Nov 2009 13:54

This problem was discussed on SDAC forum. Please view the following topic: http://www.devart.com/forums/viewtopic.php?t=12604

tpo
Posts: 3
Joined: Fri 13 Nov 2009 00:48

Post by tpo » Wed 18 Nov 2009 15:21

Many thank's for your answer.
Problem is solved.
:-)

Post Reply