| Groups | Blog | Home |
sql server notification services : how hard to set up cellphone delivery channel
guess it's a custom deliverychannel because MS only supports smtp and file as built in delivery channels. What resources are necessary in order to set up a channel like this to deliver, say, text messages to mobiles? Do we need special services or service providers to coordinate this with? TIA
I have used an external service for this. There is a site called
Clickatell.com. They have 10-messages free trial. Subscribe for it and then u can download a dll using which u can send SMS. Following is the sample code //click on button to send sms private void button1_Click(object sender, EventArgs e) { HttpWebRequest webRequest = null; HttpWebResponse webResponse = null; string uri; try { uri = "http://api.clickatell.com/http/sendmsg?"; uri += "api_id=" + "123456";//given when u subscribe uri += "&user=" + "testuser"; uri += "&password=" + "passtest"; uri += "&to=" + "912345678905";//cell no with country code uri += "&text=" + "Merry Christmas"; uri += "&from=" + "Santa"; webRequest = (HttpWebRequest)WebRequest.Create(new Uri(uri)); webRequest.ContentLength = uri.Length; webRequest.KeepAlive = false; webRequest.Method = "POST"; webResponse = (HttpWebResponse)webRequest.GetResponse(); Stream responseStream = webResponse.GetResponseStream(); StreamReader responseStreamReader = new StreamReader(responseStream); string response = responseStreamReader.ReadToEnd(); responseStreamReader.Close(); responseStream.Close(); webResponse.Close(); } catch (Exception exception) { MessageBox.Show(exception.ToString()); return; } finally { if (webRequest != null) webRequest.Abort(); webRequest = null; webResponse = null; } }
Here are a list of partners for NS.
http://www.microsoft.com/sql/technologies/notification/partners.mspx HTH.. -- Joe Webb SQL Server MVP http://www.sqlns.com ~~~ Get up to speed quickly with SQLNS http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 I support PASS, the Professional Association for SQL Server. (www.sqlpass.org) On Fri, 23 Dec 2005 08:13:14 -0600, "billdebug" [quoted text, click to view] <william.delaney@dot.state.wi.us> wrote:
>I've been cruising the information on NS and I cannot figure this out. I >guess it's a custom deliverychannel because MS only supports smtp and file >as built in delivery channels. >What resources are necessary in order to set up a channel like this to >deliver, say, text messages to mobiles? >Do we need special services or service providers to coordinate this with? >TIA
You can use any web based sms gateway and post your message from your
custom http delivery protocol to them. Kate Patterson MBCS
Do you need real SMS or just sending text to phone? Our solution is using
SMTP addresses to send to cell phones. We did define two different DeviceTypeName for subscriber devices so we can get a different stylesheet template applied, we don't send as must in the message to cell phones. This was we use the built in SMTP feature to handle the work for us. You can write your own DeliveryChannel if need be with out a lot of difficultly. We have a component that writes to MSMQ, mostly taken from the example in Shyam's book on NS. BOL has an example of writing one to call a stored proc. Data in our <InstanceName>NSMain.dbo.NSSubscriberDevices table would like the following: SubscriberID DeviceName DeviceTypeName DeviceAddress DeliveryChannel test1 SMTP1 SMTP email@here.com SMTPChannel (as per ICF below) test1 Mobile1 MobileEmail mobile@here.com SMTPChannel ICF settings: <DeliveryChannel> <DeliveryChannelName>SMTPChannel</DeliveryChannelName> <ProtocolName>SMTP</ProtocolName> <Arguments> <Argument> <Name>SmtpServer</Name> <Value>localhost</Value> </Argument> <Argument> <Name>BodyEncoding</Name> <Value>utf-8</Value> </Argument> </Arguments> </DeliveryChannel> ADF settings: <Protocol> <ProtocolName>SMTP</ProtocolName> <Fields> <Field> <FieldName>Subject</FieldName> <SqlExpression> <!-- Subject here --> </SqlExpression> </Field> <Field> <FieldName>From</FieldName> <SqlExpression> <!-- email address here --> </SqlExpression> </Field> <Field> <FieldName>To</FieldName> <SqlExpression> DeviceAddress </SqlExpression> </Field> <Field> <FieldName>Priority</FieldName> <SqlExpression> N'Normal' </SqlExpression> </Field> <Field> <FieldName>BodyFormat</FieldName> <SqlExpression> N'text' </SqlExpression> </Field> </Fields> </Protocol> In the path where our stylesheet's are stored we have a folder for each DeviceTypeName (SMTP, MobileEmail) with the appropriate stylesheet templates in them. Hopefully this helps you, or others. [quoted text, click to view] "billdebug" <william.delaney@dot.state.wi.us> wrote in message news:%23ULgEs8BGHA.3584@TK2MSFTNGP11.phx.gbl... > I've been cruising the information on NS and I cannot figure this out. I > guess it's a custom deliverychannel because MS only supports smtp and file > as built in delivery channels. > What resources are necessary in order to set up a channel like this to > deliver, say, text messages to mobiles? > Do we need special services or service providers to coordinate this with? > TIA >
Sorry about the formatting, but I also forgot we are using SQL 2005 NS.
[quoted text, click to view] "Andy Wilbourn" <andyjax@newsgroup.nospam> wrote in message news:uG9PKFSEGHA.2708@TK2MSFTNGP11.phx.gbl... > Do you need real SMS or just sending text to phone? Our solution is using > SMTP addresses to send to cell phones. We did define two different > DeviceTypeName for subscriber devices so we can get a different stylesheet > template applied, we don't send as must in the message to cell phones. > > This was we use the built in SMTP feature to handle the work for us. You > can write your own DeliveryChannel if need be with out a lot of > difficultly. We have a component that writes to MSMQ, mostly taken from > the example in Shyam's book on NS. BOL has an example of writing one to > call a stored proc. > > Data in our <InstanceName>NSMain.dbo.NSSubscriberDevices table would like > the following: > SubscriberID DeviceName DeviceTypeName DeviceAddress > DeliveryChannel > test1 SMTP1 SMTP email@here.com > SMTPChannel (as per ICF below) > test1 Mobile1 MobileEmail mobile@here.com > SMTPChannel > > ICF settings: > <DeliveryChannel> > <DeliveryChannelName>SMTPChannel</DeliveryChannelName> > <ProtocolName>SMTP</ProtocolName> > <Arguments> > <Argument> > <Name>SmtpServer</Name> > <Value>localhost</Value> > </Argument> > <Argument> > <Name>BodyEncoding</Name> > <Value>utf-8</Value> > </Argument> > </Arguments> > </DeliveryChannel> > > ADF settings: > <Protocol> > <ProtocolName>SMTP</ProtocolName> > <Fields> > <Field> > <FieldName>Subject</FieldName> > <SqlExpression> > <!-- Subject here --> > </SqlExpression> > </Field> > <Field> > <FieldName>From</FieldName> > <SqlExpression> > <!-- email address here --> > </SqlExpression> > </Field> > <Field> > <FieldName>To</FieldName> > <SqlExpression> > DeviceAddress > </SqlExpression> > </Field> > <Field> > <FieldName>Priority</FieldName> > <SqlExpression> > N'Normal' > </SqlExpression> > </Field> > <Field> > <FieldName>BodyFormat</FieldName> > <SqlExpression> > N'text' > </SqlExpression> > </Field> > </Fields> > </Protocol> > > In the path where our stylesheet's are stored we have a folder for each > DeviceTypeName (SMTP, MobileEmail) with the appropriate stylesheet > templates in them. > > Hopefully this helps you, or others. > > "billdebug" <william.delaney@dot.state.wi.us> wrote in message > news:%23ULgEs8BGHA.3584@TK2MSFTNGP11.phx.gbl... >> I've been cruising the information on NS and I cannot figure this out. I >> guess it's a custom deliverychannel because MS only supports smtp and >> file as built in delivery channels. >> What resources are necessary in order to set up a channel like this to >> deliver, say, text messages to mobiles? >> Do we need special services or service providers to coordinate this with? >> TIA >> > >
nice solution, Andy
Kate Patterson MBCS
Thanks Kate. We were not sure if this would be a bad design for a NS
solution, but the best we could come up with. I think we submitted to MS for feedback and they said it was a good way to go, so we went with it. [quoted text, click to view] "kate" <k@alert-tech.co.uk> wrote in message news:1136458022.297214.241470@g49g2000cwa.googlegroups.com... > nice solution, Andy > > Kate Patterson MBCS >
I like it!
-- Joe Webb SQL Server MVP http://www.sqlns.com ~~~ Get up to speed quickly with SQLNS http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 I support PASS, the Professional Association for SQL Server. (www.sqlpass.org) On Mon, 9 Jan 2006 13:00:02 -0500, "Andy Wilbourn" [quoted text, click to view] <andyjax@newsgroup.nospam> wrote:
>Thanks Kate. We were not sure if this would be a bad design for a NS >solution, but the best we could come up with. I think we submitted to MS for >feedback and they said it was a good way to go, so we went with it. > > > >"kate" <k@alert-tech.co.uk> wrote in message >news:1136458022.297214.241470@g49g2000cwa.googlegroups.com... >> nice solution, Andy >> >> Kate Patterson MBCS >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |