How to interface NowSMS with MS Access? | Search |
NowSMS Support Forums ⬆ NowSMS Support - SMS Issues ⬆ Archive through October 03, 2004 ⬆ |
◄ ► |
Author | Message | |||
peterjwhite Unregistered guest |
Hi, I have an idea for a 2-way SMS application where the logic is an SQL query in Microsoft Access. I haven't programmed for a few years now, so I need a simple way to pass incoming SMS directly into MS Access, where I can parse the message and run a SQL query, then send my response to NowSMS as an outbound SMS. Which standard Windows data exchange protocols are supported by NowSMS? What would be easiest one for 2-way data exchange with MS Access? | |||
Saeed Paksima New member Username: Paksima Post Number: 5 Registered: 07-2004 |
NowSMS does not currently offer APIs.The easiest way is to direct all output on the gatway to a file and then read the file through a custom application. The only other method is to code a script to accept the messages from the gateway and define it in the 2-Way SMS command fields. HTH | |||
Bryce Norwood - NowSMS Support Board Administrator Username: Bryce Post Number: 3136 Registered: 10-2002 |
Hi Peter, The easiest way to do this is to configure a 2-way command in NowSMS, where it runs an ASP script (on a separate web server) when a message is received. The details about the received message are passed as parameters to the ASP script. From ASP, you interface with your database, and you can return back a text response that gets sent back to the original SMS sender. There is a very simple example of an ASP script for 2-way SMS at the following link: http://support.nowsms.com/discus/messages/1/4420.html The above example doesn't do anything other than validate that it received a correctly formatted request, and returns the original text back to the sender. But you could use this as a base, and add database interfacing logic to it. We also have quite a few PHP examples, but nothing that shows database access from PHP. So unless you're more familiar with PHP, you might better off going the ASP route. -bn |