Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

Number of used message by the SMPP server ?
sp_NewPost Add Reply sp_NewTopic Add Topic
December 1, 2015
4:09 pm
Henk Helmantel
Forum Posts: 520
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

The SQL Connector does not have an option to store the number of message parts in one of the 'MessageLog' database fields. The only way to determine how much message parts were sent for the message is to count the number of Packet Data Units ( PDU) in the 'MessagePDU' field. This field contains the PDU of all message parts, separated by comma's.

The 'MessagePDU' field is not assigned automatically for ODBC and OLEDB databases, only for Microsoft SQL Server. To add this field manually, open the SQL Connector properties, select 'Advanced' and fill in the database field name in the 'SMSLogPDU' property.

Regards, Henk

December 1, 2015
12:12 pm
F. Velay

I'm testing this application, using a SQL connector and a SMPP Gateway. It works fine.
Is it possible to know how many messages are used by the SMPP server in the "SMS Log" table ? Some times, i have to send message with a long text. On the phone, I see only 1 message but the server has consumed 2 or 3 messages.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
6 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 354

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 512

Posts: 1774

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 520