| NowSMS and SQL |  Search
|
|
NowSMS Support Forums ⬆ NowSMS Support - SMS Issues ⬆ Archive through January 23, 2007 ⬆ |
◄ ► |
| Author | Message | |||
| luis soto New member Username: Lasq Post Number: 1 Registered: 10-2006 |
Hi, My question is regarding with the steps to follow to make the received SMS data store in a SQL Server database. To be more specific I want the data received by the nowSMS to store in a table and then that table can be accessed by another aplication. Thanks in advance for your support. | |||
| MedSalimALI Frequent Contributor Username: Salim Post Number: 107 Registered: 04-2005 |
Hi luis, When bryce will be back, he will give you some general scripts, for now, you need to build a separate script (asp or asp.net or php) and setup it in 2-way command of NowSMS. this script will get the parameters via NowSMS and store them in your database. after then you will use your windows application (VB6 or VB.net) to process any remaining scenario, and also this application may use NowSMS back to send any reply back to the users.... Salim.... | |||
| Bryce Norwood - NowSMS Support Board Administrator Username: Bryce Post Number: 6707 Registered: 10-2002 |
Hi Luis, When NowSMS receives an SMS message, it can be configured to call a script residing on a web server ... passing details of the received message to the script. This script doesn't run on NowSMS itself, it runs on a separate web server ... so you can use whatever scripting language you are familiar with ... PHP, ASP, Perl, etc. NowSMS makes an HTTP GET request, passing the details of the received message as parameters to a URL that you configure in NowSMS. The way that this works is very similar to creating a web server script that processes input from a web form, only it is NowSMS that is passing the data to your script instead of a user at a web browser. We refer to this process "2-way SMS". If you want to put the received SMS messages into an SQL Server database, then you would do this in your script that processes the received message. (I'm not an expert in SQL Server, so I can't give you pointers specific to SQL Server.) There are more pointers to information about 2-way SMS scripts and examples at the following links: http://www.nowsms.com/documentation/ProductDocumentation/2_way_sms_support.htm http://support.nowsms.com/discus/messages/1/4520.html -bn | |||
