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.
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.
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 628
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 1341