Query Notification error invalid object nameSDAC_NS_58_QUEUE
Posted: Wed 30 Jul 2008 14:09
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
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