Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

HOw to send SMS Using t-sql Expand / Collapse
Author
Message
Posted Monday, July 20, 2009 6:56 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:34 AM
Points: 90, Visits: 420
Hi,

How to send using T-SQL ( ofcourse using GSM port integration ,but how to intigrate )

Any suggestions..

Thanks in advance,....


GaNeSH
Post #755727
Posted Monday, July 20, 2009 7:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
Are you sure you want to use a local GSM gateway? If not, there are providers like ClickATell who provide several different interfaces. I like them and have used them before. Also there is no direct way to do this from SQL. With that said you could write a SQLCLR object to send them. There is a project on CodePlex called SMS Task, it might provide some code to make a SQL CLR object. It is at:
http://smstask.codeplex.com/

If you are still intent on a GSM solution there is a company, which unfortunately I can't remember their name, that have a solution that is backed by SQL Server. But it is pricey..

CEWII
Post #755775
Posted Monday, July 20, 2009 8:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:08 PM
Points: 12,903, Visits: 31,972
there's a script in the scripts ection for sending an SMS in a trigger here:http://www.sqlservercentral.com/scripts/Miscellaneous/31899/

that uses the exisitng email-to-SMS functions that every cell carrier seems to support.

there's a lot of other examples if you search for "SMS" here on SSC.

did you mean the actual modem connection and everything, or is that sufficient? there's another thread that has the actual modem handling on codeproject.com, but I'm not sure what you need.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #755786
Posted Saturday, July 25, 2009 7:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
The company that makes the SMS Gateway I was talking about is Ozeki NG.. It is at:
http://www.ozekisms.com/

CEWII
Post #759618
Posted Saturday, July 25, 2009 10:47 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:39 PM
Points: 33,155, Visits: 15,291
That gateway supports email, so sp_sendmail should work.

Don't do this from a trigger. Let the trigger drop data in a table and then use a job that checks the table every minute and sends the email.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #759653
Posted Saturday, July 25, 2009 11:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 1, 2014 1:26 PM
Points: 2,242, Visits: 3,645
In my previous organization, i'd written a sms gateway in vb 6.0 that was using a third party tool (air2web) to send SMS. The gateway had schedulers running which brought relevant details from various sources(oracle, sql server, excel files) at regular intervals defined in a 'Rules' table to an smsFetch table and a timer used to run which used to read and parse data from this smsFetch table and used to send the sms. The vendor had given us a URL with which contained userid/pin, mobileno and smstext as parameters of the URL and the timer used to invoke for each row of data.... Charges were INR 0.18 per sms for national sms and Rs 3 for international sms.

There are other vendors who provide dll's which you can incorporate (if you're planning to write a short program for it).





Pradeep Singh
Post #759659
Posted Tuesday, April 2, 2013 12:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 2, 2013 12:52 AM
Points: 2, Visits: 5
Hi
i Think
SMS gateway is highly robust, scalable with the capacity of handling a peak load of 1500 SMS per second.


Bulk SMS Gateway
Click here offers
Post #1437717
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse