Hi.
I am using SDAC 480d12pro, CBuilder 2009 and SQL Server 2008 Enterprise Eval.
This problem arises with both “SDAC compiled demo“ and my own program.
Everything works fine until trying to send the message, se printout from DBMonitor:
BEGIN DIALOG :ch FROM SERVICE :fs TO SERVICE :ts
WITH ENCRYPTION = OFF
-- 0 row(s) affected.
IF NOT EXISTS (SELECT * FROM sys.service_queues WHERE name = 'InitiatorService_QUEUE') CREATE QUEUE InitiatorService_QUEUE
IF NOT EXISTS (SELECT * FROM sys.services WHERE name = 'InitiatorService') CREATE SERVICE InitiatorService ON QUEUE InitiatorService_QUEUE([DEFAULT])
-- 0 row(s) affected.
SEND ON CONVERSATION CONVERT(uniqueidentifier, '32535257-4BBE-DE11-9AE1-005056C00008')
(:MessageBody);
Incorrect syntax near the keyword 'ON'.
The strange thing is that this do not happens if the computer has a local SQL Server 2008 Enterprise installation. The applications are in both cases connected to a remote SQL server.
Is there any services(that seems to be included in MS SQL Server 2008) required to run the Service Broker.