[dba-Tech] Send SMS From Mobile Into MS Access Or SQL Database

Paul Hartland paul.hartland at googlemail.com
Sat Feb 15 05:18:46 CST 2014


Stuart,

Sounds pretty good will look into that thank you.

Paul


On 14 February 2014 11:41, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:

> Ok, if you want to go with SMS from the device, your best bet is to instal
> an SMS server on
> your machine.   I did a lot of work on premium rate SMS services a few
> years using this:
>
> http://www.activexperts.com/mmserver/
>
> but it is over kill in your situation.  A quick google turned up this one:
>
> http://www.diafaan.com/  which looks as though it will do everything your
> want and much
> more.  (Primarily, automatically log your incoming SMSs into SQL
> Server/Access/MySQL etc
> database)
>
> $195 for the Light version plus a GSM modem and SIM card and you are in
> business.  (and
> you get a 30 day freee trial)
>
> GSM modems for $30-40 : http://www.ebay.com/bhp/usb-gsm-modem
>
> SIM card from your choice of carrier in your location: $????
>
>
> --
> Stuart
>
> On 14 Feb 2014 at 8:00, Paul Hartland wrote:
>
> > Stuart,
> >
> > I have looked at no 3 but don't want to mess with web servers at
> > present as I just have a single PC that I use at home at present and
> > not too clever on the security aspects etc as I know very little about
> > networks, for a little test last year I installed apache on my machine
> > and wrote a simple web page that people could see, but a network
> > friend of mine said if I hadn't got an external firewall box then I am
> > open to security risks.  Anyway the reason I am looking at SMS to
> > email or directly into database is because email will require a
> > connection to wi-fi or mobile data where an SMS just requires a phone
> > signal, but I have thought about a mobile app which will accept the
> > code and message then when the user presses send, turns the mobile
> > data on, sends the email and turns the mobile data off, but again this
> > could result in cost to the phone user where I imagine the majority of
> > people have unlimited texts nowadays plus you mention basic4android
> > when I could not guarantee the phone would be android and could be
> > blackberry, IOS, Windows phone or android, unless of course an
> > application developed on basic4android would work on all those.  Which
> > brings me back to SMS which will convert into an email or some gateway
> > where my application at the client site would scan every x seconds for
> > new email and strip the contents out to a database, I did use a third
> > party tool called SMS2Email at my last place of work for sending out
> > SMS via email, but was hoping to avoid a third party for turning an
> > SMS into an email.
> >
> > I am just stuck on the getting the data from any mobile device to the
> > client site as the software for the client side I can develop in a
> > couple of hours max.
> >
> > Paul
> >
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com


More information about the dba-Tech mailing list