SQL connector
|
  
|
Database properties
Select the database driver type and connection string to the database you want to use. Diafaan SMS Server supports three database driver types, Microsoft SQL Server (Express), ODBC and OLE DB.
Send SMS properties
In the Send SMS tab page you can enter the table name and the basic database field names of the database table that is polled for new messages to send. After the database records are read in, the records are either removed from the database or one of the database fields is set to a fixed value. Records where this value is set are not read anymore in successive database pollings.
If large numbers of messages will be sent it is better to remove the records from the database, leaving a large number of records in the database might have an impact on the database performance.
In the Send SMS tab page you can also use double quotes to indicate fixed values. In the example below the To part of the SMS message is not retrieved from the database but all messages are sent to number +44xxxxxxxxxx. This enables you to use database tables where no GSM number is available. The only required database field is the Index, all other fields are optional.
The Advanced settings offers support for an SMSOutScheduled date/time database field. If this database field is used individual messages are not read from the database before the specified date and time.
Receive SMS properties
Use the values in the Receive SMS tab page to specify the database table name and basic database field names where received messages are stored. More fields from the received message can be specified in the Advanced properties.
SMS Log properties
The SMS Log database table is used to store the result of message send attempts. Specify the database table name and basic database field names where the message logs are stored. More fields can be specified in the Advanced properties.
The Message Status Code field stores the message result. Status codes between 200 and 299 indicate that the message is sent successfully. Status codes between 300 and 399 means that the message failed.
status codes
200 |
Message sent and accepted by the gateway. |
201 |
Message received on the GSM phone. |
300 |
Message failed or rejected by the gateway. |
301 |
Status error received after the message was accepted by the gateway |
The message status can be updated, this means that a message with status code 200 (accepted by the gateway) can change to status code 301 if the GSM network cannot deliver the message.
Advanced properties
DatabaseCheckInterval
The time interval in seconds between two queries of the Send SMS database table.
MaximumBatchSize
The maximum number of database records this connector will process in one batch. If this value is higher than one and a number of messages are sent at the same time, the connector loads multiple messages concurrently. This increases the speed in which the messages are processed considerably.
SQLFlavor
The type of database that is used, changing this value causes small changes in the SQL query strings to optimize performance.
database types
AnsiSQL92 |
Standard ANSI SQL |
Microsoft |
Implements the TOP keyword |
Oracle |
Implements the ROWNUM keyword |
MySQL |
Implements the LIMIT keyword |
Database field names
Additional database field names can be entered to query or store more parts of the sent or received message fields.