SQL2GSM is an application that can help you to build SMS/EMS/SM services. You can simply configure almost any SQL query that might be processed if preconfigured SMS is received.
For simple example you can easily set in SQL2GSM that if SMS in format: PASSWORD [number] (where [number] is some number) is received then SQL query SELECT * FROM passwords WHERE identification=[number] has to be processed in your database. When SQL2GSM receive back from SQL database results for that query it can be sent back to sender (depends on the configuration of each query).
SQL2GSM can also act as SMS forwarder or SMS gateway. You can forward incoming SMS to specified phone(s).
There is aslo new possibility to communicate with SQL2GSM over TCP/IP (see bellow).
SQL2GSM has very simple interface for fast and effective configuration.
You can very easily create sql query in SQL2GSM. You can not even know the SQL syntax (but it is recommended) to
create simple queries.
SQL2GSM supports variety SQL servers like MySQL, MSSQL, PgSQL, Firebird, Interbase and Sybase which you can connect to.
Reply for SMS can be send as classic text (SMS) or SM melody, SM picture, EMS melody and EMS picture.
For each sql query can be set different error messages that can be sent to sender or just shown in the log.
You can set filter to allow or deny a range of phone numbers or exact number. Each filter can be set for specific sql query or forwarding and/or can be set as default filter.
If you would like to setup SMS Gateway or SMS forwarding you can create (with PREFIX) new forwarding and add as many phones as you can.
SQL2GSM can then forward incoming SMS to set phone(s) or send to those phones predefined message.
Everything is logged into GSM log and set off by colours. Log file is saved in text format.
There is also GSM terminal to see all AT messages sent to GSM modem and response for them. Also this log is saved into the text file and can be used for debugging and tracing the problems.
TCP/IP server allows you to connect "third-party" applications (clients) to SQL2GSM and receive selected meesage types from selected modems. There is also possibility to send SMS over those clients.
All the statistics (incoming/outgoing SMS) are saved in XML format so you can show them via web service or use them in other applications (collecting statistics etc.).
Almost all settings is in this format so there is no problem to setup SQL2GSM remotely over website.
Supported GSM modems/phones
Number of supported modems is growing.
These folowing modems/phones should work with SQL2GSM:
* Siemens A1
* Siemens M1
* Siemens M20
* Siemens TC35
* Ericsson GM12
* Nokia 6210
* Nokia 9110
* Nokia 6650
* Siemens M35
* Siemens S35
* Siemens S55
* Siemens C45
* Siemens ME/S45
* Motorola Timeport T260
* Wavecom
* Wavecom Fasttrack
* Fargo Maestro
Note: if you can not find your modem type in the list, that does not mean that this modem is not supported - it means that this modem type was not tested yet. Try your modem with Demo version first.
System Requirements
* Microsoft Windows Vista, Windows 2003, Windows 2000, Windows XP, Windows NT4, Windows 98
* GSM modem/phone (see the list above)
