Hi guys,
Is there any way to send an SMS through SQL Server 2008?
+2
A:
One possible option is to use an SMS gateway like the Clickatell API.
The Clickatell API offers a choice of connection options, including an SMTP method which you can use by sending a plain-text email from SQL Server to [email protected], with the following body:
user: your_api_username
password: your_api_password
api_id: your_api_id
to: sms_number
text: sms_body
To send e-mails from SQL Server 2008, you might want to check out the following article:
Another option is to write a CLR stored procedure that communicates with the SMS gateway through any protocol supported by the gateway.
Daniel Vassallo
2010-01-12 08:44:37
+1
A:
A simple way would be to write a CLR procedure that sends the sms via http to a SMS gateway of your choice
Conrad
2010-01-12 08:45:59
+1
A:
I found an article which uses c# application with a SQL Server Backend to send SMS emails. Not exactly what your after but may give you another option.
kevchadders
2010-01-12 08:47:07
+2
A:
Yes, although not natively. You will have to use an SMS gateway service and do some programming around it. These come in several formats, occasionally free, but normally with some form of per message charge.
Standard gateways will accept message requests via email, a web post, or a full web service. Depending on the gateway service it may offer one, some, or all of these options.
Back in the "olden days" when I mobile SMS started to take off, in the UK at least, it was also possible to use a dial up modem to dial a network specific number and enter the SMS message. If this is still available in the area that you are looking for then the advantage of this is no account setup as it's charged to your phone bill.
Doogie
2010-01-12 13:31:37
Or use a GSM modem (or these days just about any mobile phone with bluetooth).But you still need some software to bridge the database to the device driver.C.
symcbean
2010-01-13 09:21:12
Ah yes, I was so deep in old-man-land that I forgot about GSM terminals, mobiles with a data cable, mobiles with bluetooth, or mobile broadband dongles. Thanks!
Doogie
2010-01-13 12:45:04