SMS stored in Access...

SMS stored in Access... SearchSearch

NowSMS Support Forums » NowSMS Support - SMS Issues » Archive through June 02, 2006 » SMS stored in Access... « Previous || Next »
Author Message
Sarah A.
New member
Username: Sarah83

Post Number: 3
Registered: 01-2006
Posted on Tuesday, May 09, 2006 - 12:58 pm:   

Hi all,,

Senior Computer Engineering Student and doing a senior project, the smallest part and which I thought it will be the easiest became a problem.. Few days to submit the report and do the presentation..

May request:
I tried the nowSMS in receiving and replaying by echo sms to the sender and it works fine; however, I need to receive the SMS and store the data in a Database (Access)..

So please help me as fast as possible.

Bryce Norwood - NowSMS Support
Board Administrator
Username: Bryce

Post Number: 5914
Registered: 10-2002
Posted on Tuesday, May 09, 2006 - 06:00 pm:   

I'm not a database expert (and besides, I like to see students work for their degrees <g>) ...

But, here's some general advice ...

When NowSMS receives an SMS message, it can either execute a command line program, or it can issue an HTTP request.

So, how would you interface to your database from within a command line program? (Hint: The easiest way to do this might be a quick JScript or VBScript running under the Windows script host.)

Or how would you interface with your database from a web page? When NowSMS uses a 2-way command that is HTTP based, the URL request that it makes works much like a standard form on a web page. So how would you do this with an ASP script, Perl script or PHP script running on a web server?

The HTTP approach requires a web server environment under which your script can execute.

The Windows script host (cscript.exe) command line interface is a good solution when you don't have (or want) a web server as part of the configuration. Here's an old example of a script that simply processes a received message and writes it to a log file:

Note: I usually use cscript.exe to run these scripts instead of wscript.exe referenced in that example.

You can probably find examples of JScript or VBScript, running under the Windows script host, interfacing to an Access database with an internet search.

Focus on getting a working script that can accept command line parameters to insert your record into the database ... and once you have that working, then configure it as a 2-way command for processing received SMS.