Post reply

SMS from SQL Server

  • July 17, 2009 at 7:45 am

    #136360

    Hi ,

    I need to send SMS from my application,

    How to send SMS from sql server...

    Can you please suggest me..?

    Thanks in Advance

    GaNeSH

  • July 17, 2009 at 7:55 am

    #1026190

    I searched for "SMS .NET" in Bing, and this was one of the first results:

    http://www.codeproject.com/KB/IP/Sending_SMS_using_Net.aspx

    Will that do what you need?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • July 17, 2009 at 8:17 am

    #1026202

    1. Transforming all the cell numbers you need to send SMS to as Email addresses according to the rules found in this article

    2. Put the numbers and transformed email addresses in a table

    3. Using Send DB mail to send email to the addresses

    Hope this will help.

  • July 17, 2009 at 9:32 am

    #1026261

    Sending SMS directly from any app requires a GSM modem/gateway and software to handle it. There's options to use services that offer that, but most have minimum commitments and hence expensive.

    The cheapest (as in Free) is as suggested above.

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • July 17, 2009 at 9:43 am

    #1026274

    There is a component on Codeplex to do it from SSIS.. Let me find it...

    http://smstask.codeplex.com/

    If nothing else, it could give you some ideas on how to implement it in a SQL CLR if SSIS doesn't work for you.

    And in a shameless plug (although I don't work for them), I REALLY like ClickATell (not sure of spelling).

    There were some references to sending to email addresses, that works as well, but you have to know what their phone provider is for every recipient, with an SMS gateway (ie: Clickatell) you don't have to care, BUT you have to pay for each text, to the tune of about 4 cents/per.

    Pick your poison..

    CEWII

  • April 2, 2013 at 12:49 am

    #1602678

    Hi

    Good Question,

    But,

    Our SMS gateway lets you get connected to your customers, promote yourself via text SMS, long messages, WAP push, business card & Flash messaging

    Bulk SMS Gateway
    Click here offers

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply