Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

How to Choose Gateway from one SQL Connector
sp_NewPost Add Reply sp_NewTopic Add Topic
November 21, 2016
9:27 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

November 21, 2016
2:40 am

Hi Henk,

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!

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502