If you want to send a message from the SQL database with a specific gateway, you can use the 'Gateway' field of the SQL database. You do not need a separate SQL Connector to route the messages to a specific gateway. The 'Gateway' database field can be set to the gateway name (e.g. 'GSM Modem Gateway') or to a list of gateway names separated by semicolons (e.g. 'GSM Modem Gateway 1;GSM Modem Gateway 2').
There are two things to consider when you use the 'Gateway' field. The first is that messages will only be routed to gateways that are in the routing list of the connector. In other words, the 'Gateway' field can only be used to limit the connector specific routing. If the gateway is not in the connector routing list, Diafaan SMS Server will return an error that there is no gateway available to send the message.
The second issue to consider is that you have to check whether the 'SMSOutGateway' property in the advanced setting of the SQL Connector points to the correct database field name. If you use a Microsoft SQL Server database and use the wizard to create the database this field is automatically assigned the correct value. But if you use a MySQL, Access or Oracle database, you have to assign these fields manually after the new SQL Connector is created.
Need your help once again. I'm still developing our application, I have added one SMS Modem Gateway which handles a SIM card from a different network from the first one. Now, I'm having a confusion on how will the SQL connector determine which Gateway will he send the message from the MessageOut table on the database. My first assumption was only to provide the Gateway Name I have made from the Diafaan SMS Server to the 'Gateway' column on my MessageOut table.
I don't think I need to make another SQL connector or do I? I have noticed also a 'Gateway' column on the MessageLog which is just auto null for all the records, should I make use of this also? Please advise.
Hope you can help me with this again. Thank you!
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 384
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 598