Support forum

Hello Yuz,

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.

Regards, Henk