TMSServiceBroker, problem sending messages

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
kme
Posts: 5
Joined: Wed 21 Oct 2009 13:00

TMSServiceBroker, problem sending messages

Post by kme » Wed 21 Oct 2009 13:52

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.

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

Post by Dimon » Mon 26 Oct 2009 11:33

Please, try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

Post Reply