Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

SQL Script to send sms to many subscriber from the SQL Database Connected to the DIafaan SMSC server
sp_NewPost Add Reply sp_NewTopic Add Topic
February 1, 2022
10:46 am
Patrick Cobba

Hello Henk,

thanks a lot for your support.the command worked perfectly.

February 1, 2022
10:00 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Patrick,

With the standard database layout that the SQL Connector in Diafaan SMS Server uses, the SQL command will be:

INSERT INTO MessageOut (MessageTo, MessageText) VALUES ('+224664222543', 'Batch SMS Test');

The names of the database table and the database fields can be changed in the settings of the SQL Connector, so depending on your database layout, the SQL command to add new messages to the database could be different.

Regards, Henk

January 31, 2022
7:20 pm
Patrick Cobba

i have been able to successfully connect the Microsoft SQL database to the Diafaan SMS Gateway.
please what is the SQL script to use to insert the text message,number etc from the sql query window.

see an example of a similar script for an SQL Database server to (another SMS server that is not Diafaan)

insert into svgmessageout (receiver,msg,status) values ('+224664222543','Batch SMS Test ','Send');
insert into svgmessageout (receiver,msg,status) values ('+224623645792','Batch SMS Test ','Send');
insert into svgmessageout (receiver,msg,status) values ('+224625777765','Batch SMS Test ','Send');
insert into svgmessageout (receiver,msg,status) values ('+224623264969','Batch SMS Test ','Send');

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
2 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