Invalid object name ’SDAC_NS_58_QUUE’
Posted: 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
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