Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

HTTPDeliveryProtocol

 
   Database Forums (Home) -> Notification Services RSS
Next:  W2k3 / Sql 2K Contection pb  
Author Message
msakarya

External


Since: Jan 31, 2005
Posts: 7



(Msg. 1) Posted: Mon Jan 31, 2005 3:40 pm
Post subject: HTTPDeliveryProtocol
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

Is it logical to implement an "HTTPDeliveryProtocol" which makes thousands
of request to a web server - may be some server in the same network, which
can handle 200 requests per second ?
Or should I implement a "MQDeliveryProtocol" which makes HTTPRequests,
asynchronously (where I cannot keep track of a notifications whether they
are succeeded)?

Mert

 >> Stay informed about: HTTPDeliveryProtocol 
Back to top
Login to vote
Colin Meek MSFT

External


Since: Aug 19, 2004
Posts: 59



(Msg. 2) Posted: Mon Jan 31, 2005 3:47 pm
Post subject: Re: HTTPDeliveryProtocol [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Mert,

I would suggest implementing the IHttpProtocolProvider interface, which
allow NS to handle most of the infrastructure you require, including
asynchronous requests.

You can find more information in NS books online:

<a rel="nofollow" style='text-decoration: none;' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/nsp_advancedtopics_2b5f.asp" target="_blank">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlnt...htm/nsp</a>
<a rel="nofollow" style='text-decoration: none;' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/nsp_objectmodel2_4sdx.asp" target="_blank">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlnt...htm/nsp</a>

- Colin Meek [MSFT]

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
<a rel="nofollow" style='text-decoration: none;' href="http://www.microsoft.com/info/cpyright.htm." target="_blank">http://www.microsoft.com/info/cpyright.htm.</a>

Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
--

"Mert Sakarya" wrote in message

 > Is it logical to implement an "HTTPDeliveryProtocol" which makes thousands
 > of request to a web server - may be some server in the same network, which
 > can handle 200 requests per second ?
 > Or should I implement a "MQDeliveryProtocol" which makes HTTPRequests,
 > asynchronously (where I cannot keep track of a notifications whether they
 > are succeeded)?
 >
 > Mert
 >
 >

 >> Stay informed about: HTTPDeliveryProtocol 
Back to top
Login to vote
msakarya

External


Since: Jan 31, 2005
Posts: 7



(Msg. 3) Posted: Mon Jan 31, 2005 7:40 pm
Post subject: Re: HTTPDeliveryProtocol [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks. I have done that...

HTTPDeliveryProtocol is like.... (which compiled fine)

using System;
using Microsoft.SqlServer.NotificationServices;
using System.Net;

namespace HTTPDeliveryProtocol {
public class HTTPDeliveryProtocol : IHttpProtocolProvider
.......


And My Configuration file contains...

<Protocols>
<Protocol>
<ProtocolName>SMS</ProtocolName>
<ClassName>HttpExtension</ClassName>
</Protocol>
</Protocols>

<DeliveryChannels>
<DeliveryChannel>
<DeliveryChannelName>SMSChannel</DeliveryChannelName>
<ProtocolName>SMS</ProtocolName>
<Arguments>
<Argument>
<Name>ProtocolProviderClassName</Name>
<Value>HTTPDeliveryProtocol</Value>
</Argument>
<Argument>
<Name>ProtocolProviderAssemblyName</Name>
<Value>C:\SQL-NS\XX\DeliveryProtocol\HttpDeliveryProtocol.dll</Value>
</Argument>
<Argument>
<Name>PostURL</Name>
<Value>http://localhost/webapplication2/data.aspx</Value>
</Argument>
</Arguments>
</DeliveryChannel>

ADF contains...
<Protocols>
<Protocol>
<ProtocolName>SMS</ProtocolName>
<Fields>
<Field><FieldName>BodyFormat</FieldName><SqlExpression>N'text'</SqlExpression></Field>
</Fields>
</Protocol>
Note I don't use the BodyFormat field. But I will...

I subscribed a user to the SMS Channel... When I fire an event, File evens
work fine, but SMS events give the following error in my Event Log

<NotificationServicesEvent>
<Description>
The protocol provider could not be loaded because the assembly or class
name is not valid.
</Description>
<Context>
<EventParameters>
<Protocol name>SMS</Protocol name>
<Provider class name>HTTPDeliveryProtocol</Provider class name>
<Provider assembly
name>C:\SQL-NS\XX\DeliveryProtocol\HttpDeliveryProtocol.dll</Provider
assembly name>
</EventParameters>

</Context>
<Description>
Value cannot be null.
</Description>
<Instance>XX</Instance>
<ApplicationName>XX</ApplicationName>
<Component>Distributor</Component>
<ComponentDetails>
DistributorName: XXDist1
</ComponentDetails>
<Thread>16</Thread>
</NotificationServicesEvent>

Can you help???




"Colin Meek [MSFT]" wrote in message

 > Hi Mert,
 >
 > I would suggest implementing the IHttpProtocolProvider interface, which
 > allow NS to handle most of the infrastructure you require, including
 > asynchronous requests.
 >
 > You can find more information in NS books online:
 >
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/nsp_advancedtopics_2b5f.asp</font" target="_blank">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlnt...htm/nsp</a>>
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/nsp_objectmodel2_4sdx.asp</font" target="_blank">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlnt...htm/nsp</a>>
 >
 > - Colin Meek [MSFT]
 >
 > --
 > This posting is provided "AS IS" with no warranties, and confers no
 > rights.
 > Use of included script samples are subject to the terms specified at
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.microsoft.com/info/cpyright.htm.</font" target="_blank">http://www.microsoft.com/info/cpyright.htm.</font</a>>
 >
 > Please do not send e-mail directly to this alias. This alias is for
 > newsgroup purposes only.
 > --
 >


  >> Is it logical to implement an "HTTPDeliveryProtocol" which makes
  >> thousands
  >> of request to a web server - may be some server in the same network,
  >> which
  >> can handle 200 requests per second ?
  >> Or should I implement a "MQDeliveryProtocol" which makes HTTPRequests,
  >> asynchronously (where I cannot keep track of a notifications whether
  >> they
  >> are succeeded)?
  >>
  >> Mert
  >>
  >>
 >
 >
 >> Stay informed about: HTTPDeliveryProtocol 
Back to top
Login to vote
Colin Meek MSFT

External


Since: Aug 19, 2004
Posts: 59



(Msg. 4) Posted: Tue Feb 01, 2005 3:53 pm
Post subject: Re: HTTPDeliveryProtocol [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You need to include the namespace for "ProtocolProviderClassName" as well.

- Colin Meek [MSFT]

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
<a rel="nofollow" style='text-decoration: none;' href="http://www.microsoft.com/info/cpyright.htm." target="_blank">http://www.microsoft.com/info/cpyright.htm.</a>

Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
--

"Mert Sakarya" wrote in message
news:#QD2NB8BFHA.1564@TK2MSFTNGP09.phx.gbl...
 > Thanks. I have done that...
 >
 > HTTPDeliveryProtocol is like.... (which compiled fine)
 >
 > using System;
 > using Microsoft.SqlServer.NotificationServices;
 > using System.Net;
 >
 > namespace HTTPDeliveryProtocol {
 > public class HTTPDeliveryProtocol : IHttpProtocolProvider
 > .......
 >
 >
 > And My Configuration file contains...
 >
 > <Protocols>
 > <Protocol>
 > <ProtocolName>SMS</ProtocolName>
 > <ClassName>HttpExtension</ClassName>
 > </Protocol>
 > </Protocols>
 >
 > <DeliveryChannels>
 > <DeliveryChannel>
 > <DeliveryChannelName>SMSChannel</DeliveryChannelName>
 > <ProtocolName>SMS</ProtocolName>
 > <Arguments>
 > <Argument>
 > <Name>ProtocolProviderClassName</Name>
 > <Value>HTTPDeliveryProtocol</Value>
 > </Argument>
 > <Argument>
 > <Name>ProtocolProviderAssemblyName</Name>
 >
<Value>C:\SQL-NS\XX\DeliveryProtocol\HttpDeliveryProtocol.dll</Value>
 > </Argument>
 > <Argument>
 > <Name>PostURL</Name>
 > <Value>http://localhost/webapplication2/data.aspx</Value>
 > </Argument>
 > </Arguments>
 > </DeliveryChannel>
 >
 > ADF contains...
 > <Protocols>
 > <Protocol>
 > <ProtocolName>SMS</ProtocolName>
 > <Fields>
 >
<Field><FieldName>BodyFormat</FieldName><SqlExpression>N'text'</Sq
lExpression></Field>
 > </Fields>
 > </Protocol>
 > Note I don't use the BodyFormat field. But I will...
 >
 > I subscribed a user to the SMS Channel... When I fire an event, File evens
 > work fine, but SMS events give the following error in my Event Log
 >
 > <NotificationServicesEvent>
 > <Description>
 > The protocol provider could not be loaded because the assembly or class
 > name is not valid.
 > </Description>
 > <Context>
 > <EventParameters>
 > <Protocol name>SMS</Protocol name>
 > <Provider class name>HTTPDeliveryProtocol</Provider class name>
 > <Provider assembly
 > name>C:\SQL-NS\XX\DeliveryProtocol\HttpDeliveryProtocol.dll</Provider
 > assembly name>
 > </EventParameters>
 >
 > </Context>
 > <Description>
 > Value cannot be null.
 > </Description>
 > <Instance>XX</Instance>
 > <ApplicationName>XX</ApplicationName>
 > <Component>Distributor</Component>
 > <ComponentDetails>
 > DistributorName: XXDist1
 > </ComponentDetails>
 > <Thread>16</Thread>
 > </NotificationServicesEvent>
 >
 > Can you help???
 >
 >
 >
 >


  > > Hi Mert,
  > >
  > > I would suggest implementing the IHttpProtocolProvider interface, which
  > > allow NS to handle most of the infrastructure you require, including
  > > asynchronous requests.
  > >
  > > You can find more information in NS books online:
  > >
  > >
<a rel="nofollow" style='text-decoration: none;' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/nsp_advancedtopics_2b5f.asp" target="_blank">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlnt...htm/nsp</a>
  > >
<a rel="nofollow" style='text-decoration: none;' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/nsp_objectmodel2_4sdx.asp" target="_blank">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlnt...htm/nsp</a>
  > >
  > > - Colin Meek [MSFT]
  > >
  > > --
  > > This posting is provided "AS IS" with no warranties, and confers no
  > > rights.
  > > Use of included script samples are subject to the terms specified at
<font color=green>  > > <a rel="nofollow" style='text-decoration: none;' href="http://www.microsoft.com/info/cpyright.htm.</font" target="_blank">http://www.microsoft.com/info/cpyright.htm.</font</a>>
  > >
  > > Please do not send e-mail directly to this alias. This alias is for
  > > newsgroup purposes only.
  > > --
  > >


   > >> Is it logical to implement an "HTTPDeliveryProtocol" which makes
   > >> thousands
   > >> of request to a web server - may be some server in the same network,
   > >> which
   > >> can handle 200 requests per second ?
   > >> Or should I implement a "MQDeliveryProtocol" which makes HTTPRequests,
   > >> asynchronously (where I cannot keep track of a notifications whether
   > >> they
   > >> are succeeded)?
   > >>
   > >> Mert
   > >>
   > >>
  > >
  > >
 >
 >
 >> Stay informed about: HTTPDeliveryProtocol 
Back to top
Login to vote
msakarya

External


Since: Jan 31, 2005
Posts: 7



(Msg. 5) Posted: Wed Feb 02, 2005 5:40 pm
Post subject: Re: HTTPDeliveryProtocol [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks. Worked. This thing is cool!!!

Once one gets the notion, it is easy to enhance the system...


"Colin Meek [MSFT]" wrote in message

 > You need to include the namespace for "ProtocolProviderClassName" as well.
 >
 > - Colin Meek [MSFT]
 >
 > --
 > This posting is provided "AS IS" with no warranties, and confers no
 > rights.
 > Use of included script samples are subject to the terms specified at
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.microsoft.com/info/cpyright.htm.</font" target="_blank">http://www.microsoft.com/info/cpyright.htm.</font</a>>
 >
 > Please do not send e-mail directly to this alias. This alias is for
 > newsgroup purposes only.
 > --
 >


  >> Thanks. I have done that...
  >>
  >> HTTPDeliveryProtocol is like.... (which compiled fine)
  >>
  >> using System;
  >> using Microsoft.SqlServer.NotificationServices;
  >> using System.Net;
  >>
  >> namespace HTTPDeliveryProtocol {
  >> public class HTTPDeliveryProtocol : IHttpProtocolProvider
  >> .......
  >>
  >>
  >> And My Configuration file contains...
  >>
  >> <Protocols>
  >> <Protocol>
  >> <ProtocolName>SMS</ProtocolName>
  >> <ClassName>HttpExtension</ClassName>
  >> </Protocol>
  >> </Protocols>
  >>
  >> <DeliveryChannels>
  >> <DeliveryChannel>
  >> <DeliveryChannelName>SMSChannel</DeliveryChannelName>
  >> <ProtocolName>SMS</ProtocolName>
  >> <Arguments>
  >> <Argument>
  >> <Name>ProtocolProviderClassName</Name>
  >> <Value>HTTPDeliveryProtocol</Value>
  >> </Argument>
  >> <Argument>
  >> <Name>ProtocolProviderAssemblyName</Name>
  >>
 > <Value>C:\SQL-NS\XX\DeliveryProtocol\HttpDeliveryProtocol.dll</Value>
  >> </Argument>
  >> <Argument>
  >> <Name>PostURL</Name>
  >> <Value>http://localhost/webapplication2/data.aspx</Value>
  >> </Argument>
  >> </Arguments>
  >> </DeliveryChannel>
  >>
  >> ADF contains...
  >> <Protocols>
  >> <Protocol>
  >> <ProtocolName>SMS</ProtocolName>
  >> <Fields>
  >>
 > <Field><FieldName>BodyFormat</FieldName><SqlExpression>N'text'</Sq
 > lExpression></Field>
  >> </Fields>
  >> </Protocol>
  >> Note I don't use the BodyFormat field. But I will...
  >>
  >> I subscribed a user to the SMS Channel... When I fire an event, File
  >> evens
  >> work fine, but SMS events give the following error in my Event Log
  >>
  >> <NotificationServicesEvent>
  >> <Description>
  >> The protocol provider could not be loaded because the assembly or class
  >> name is not valid.
  >> </Description>
  >> <Context>
  >> <EventParameters>
  >> <Protocol name>SMS</Protocol name>
  >> <Provider class name>HTTPDeliveryProtocol</Provider class name>
  >> <Provider assembly
  >> name>C:\SQL-NS\XX\DeliveryProtocol\HttpDeliveryProtocol.dll</Provider
  >> assembly name>
  >> </EventParameters>
  >>
  >> </Context>
  >> <Description>
  >> Value cannot be null.
  >> </Description>
  >> <Instance>XX</Instance>
  >> <ApplicationName>XX</ApplicationName>
  >> <Component>Distributor</Component>
  >> <ComponentDetails>
  >> DistributorName: XXDist1
  >> </ComponentDetails>
  >> <Thread>16</Thread>
  >> </NotificationServicesEvent>
  >>
  >> Can you help???
  >>
  >>
  >>
  >>


   >> > Hi Mert,
   >> >
   >> > I would suggest implementing the IHttpProtocolProvider interface, which
   >> > allow NS to handle most of the infrastructure you require, including
   >> > asynchronous requests.
   >> >
   >> > You can find more information in NS books online:
   >> >
   >> >
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/nsp_advancedtopics_2b5f.asp</font" target="_blank">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlnt...htm/nsp</a>>
   >> >
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/nsp_objectmodel2_4sdx.asp</font" target="_blank">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlnt...htm/nsp</a>>
   >> >
   >> > - Colin Meek [MSFT]
   >> >
   >> > --
   >> > This posting is provided "AS IS" with no warranties, and confers no
   >> > rights.
   >> > Use of included script samples are subject to the terms specified at
<font color=brown>   >> > <a rel="nofollow" style='text-decoration: none;' href="http://www.microsoft.com/info/cpyright.htm.</font" target="_blank">http://www.microsoft.com/info/cpyright.htm.</font</a>>
   >> >
   >> > Please do not send e-mail directly to this alias. This alias is for
   >> > newsgroup purposes only.
   >> > --
   >> >


   >> >> Is it logical to implement an "HTTPDeliveryProtocol" which makes
   >> >> thousands
   >> >> of request to a web server - may be some server in the same network,
   >> >> which
   >> >> can handle 200 requests per second ?
   >> >> Or should I implement a "MQDeliveryProtocol" which makes HTTPRequests,
   >> >> asynchronously (where I cannot keep track of a notifications whether
   >> >> they
   >> >> are succeeded)?
   >> >>
   >> >> Mert
   >> >>
   >> >>
   >> >
   >> >
  >>
  >>
 >
 >
 >> Stay informed about: HTTPDeliveryProtocol 
Back to top
Login to vote
Mert

External


Since: Oct 13, 2008
Posts: 1



(Msg. 6) Posted: Mon Oct 13, 2008 7:25 pm
Post subject: RE: HTTPDeliveryProtocol [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

hi Mert,
I am developing the same kind of application that notifies using sms.
can you help me out with some sample code for the custom delivery protocol?

From http://www.developmentnow.com/g/110_2005_1_0_0_403482/HTTPDeliveryProtocol.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/
 >> Stay informed about: HTTPDeliveryProtocol 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
NS API Question - Is it possible to have an arseembly in SQL 2005 to expose the NS API? The idea is to have interfaces exposed as web services from SQL 2005 directly that allow for the management of NS subscriptions. This would allow the existing ASP.Net 1.1 code to cal...

Clean out??? - I was asked to look into a problem a customer was having , Turned out they moved SMTP server and in the process the generator got disabled. This was back in May. So I have that all squared away and now I'm looking for a quick way to clear out the..

sql mail integration - i have configured sql mail in sql server 2000. the mailid is also successfully getting tested. but when i execute the xp_sendmail command i get the following error Server: Msg 18025, Level 16, State 1, Line 0 xp_sendmail: failed with mail error..

SMTP To Name - My messages are going through successfully via SMTP, but the To field does not show the email address of the person. If you look at the SMTP message with notepad you see X-Receiver: <email address>, but there is not a To: field declared. Is thi...

How to handle dead notifications at Final Retry - Notification services allows you to define number of retry attempts for the notification delivery. In addition to retry, I need to apply specific logic handle those undeliverable notifications (failed in all retry attempts) I would like to know is there...
   Database Forums (Home) -> Notification Services All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]