CLR Stored Procedure Exception
-
i am writing a stored procedure for this purpose only . "i have a table of messages , i need the data base to notify my windows service that a scheduled message would be sent now , transfering at least the message id to the windows service" i tried to use .net Remoting for that purpose but i figured out that .net remoting namespace can't be included in such a solution . then i tried to use sockets to open ports through the data base to the windows service that exist on the same machine that will listen for incoming data from that clr stored Procedure . i successfully made that second choice but the problem with that , when i try to invoke the send method of udp client , it gives me an exception of socket exception tells me socket permission request had failed , how can i grant socket access to the CLR Stored Procedure knowing i tried to configure the code access security configuration manager in the administrative tools but in vain anyone knows how to solve that problem either that of sockets or give me a whole new solution to the above problem would be great thanks in advance
Human knowledge belongs to the world.
-
i am writing a stored procedure for this purpose only . "i have a table of messages , i need the data base to notify my windows service that a scheduled message would be sent now , transfering at least the message id to the windows service" i tried to use .net Remoting for that purpose but i figured out that .net remoting namespace can't be included in such a solution . then i tried to use sockets to open ports through the data base to the windows service that exist on the same machine that will listen for incoming data from that clr stored Procedure . i successfully made that second choice but the problem with that , when i try to invoke the send method of udp client , it gives me an exception of socket exception tells me socket permission request had failed , how can i grant socket access to the CLR Stored Procedure knowing i tried to configure the code access security configuration manager in the administrative tools but in vain anyone knows how to solve that problem either that of sockets or give me a whole new solution to the above problem would be great thanks in advance
Human knowledge belongs to the world.
I would probably forget the manually socket solution you came up with and look into SQL Server Notification Service.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
I would probably forget the manually socket solution you came up with and look into SQL Server Notification Service.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
How about using MSMQ. Thus the db can send a message to the que using CLR integration in the SQL db, and the service can pick it up from there.
alex_nel
Depending on what information he needs to convey to the clients, that's possible. Notification services can be more appropriate and has a lighter overhead than MSMQ.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008