从 C# Win CE 向 SQL Server 消息队列发送消息

本文关键字:消息 队列 Server SQL Win CE | 更新日期: 2023-09-27 17:56:54

我在SQL Server ITSERVER上的数据库cja中有一个名为log_line_queue的队列。

我有一个在移动设备上运行的 C# Win CE 应用程序。我想从此应用程序向log_line_queue发送消息。

这是我到目前为止的代码:

var myQueue = new System.Messaging.MessageQueue("FormatName:Direct=OS:itserver''private$''dbo.cja.log_line_queue");
myQueue.Send("My Message Data.", MessageQueueTransactionType.Automatic);

它导致

System.Messaging.MessageQueueException: Message Queue service is not available.
   at System.Messaging.MessageQueue.MQCacheableInfo.get_WriteHandle()
   at System.Messaging.MessageQueue.StaleSafeSendMessage(MQPROPS properties, IntPtr transaction)
   at System.Messaging.MessageQueue.SendInternal(Object obj, MessageQueueTransactionType transactionType)
   at System.Messaging.MessageQueue.Send(Object obj, MessageQueueTransactionType transactionType)
   at cjaTest1.MessageQueue.FrmSendToQueue.button1_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.ButtonBase.WnProc(WM wm, Int32 wParam, Int32 lParam)
   at System.Windows.Forms.Control._InternalWnProc(WM wm, Int32 wParam, Int32 lParam)
   at Microsoft.AGL.Forms.EVL.EnterModalDialog(IntPtr hwnModal)
   at System.Windows.Forms.Form.ShowDialog()
   at cjaTest1.FrmMainForm.button9_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.ButtonBase.WnProc(WM wm, Int32 wParam, Int32 lParam)
   at System.Windows.Forms.Control._InternalWnProc(WM wm, Int32 wParam, Int32 lParam)
   at Microsoft.AGL.Forms.EVL.EnterMainLoop(IntPtr hwnMain)
   at System.Windows.Forms.Application.Run(Form fm)
   at cjaTest1.Program.Main()

确定我做错了很多事情。欢迎提出建议。

从 C# Win CE 向 SQL Server 消息队列发送消息

System.Messaging.MessageQueue用于

与 MSMQ 交互。 A queue called log_line_queue in database cja on SQL Server ITSERVER可以是表,也可以是服务代理队列。这是苹果和橙子,MSMQ与SQL Server无关。若要将消息发送到 SQL Server 队列,必须使用 SEND T-SQL 谓词,并且必须连接到 SQL Server 实例。