Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_TopicIcon
Receive Flash SMS to SQL Server Table
sp_NewPost Add Reply sp_NewTopic Add Topic
January 22, 2015
10:46 am
Filip
Guest
Guests

Hi

Found the faulting code.
It was a SQL Function inside the Trigger.
Working fine now, but I will consider recode and move the Trigger function to a Scripting Connector instead.

Thank you

Regards Filip

January 22, 2015
8:57 am
Filip
Guest
Guests

Hi Henk
As always - you are right :o)

22-01-2015 08:35:10 String or binary data would be truncated. SQL Connector

I have a Trigger on the MessageIn table. I think I have a datatype size error inside the trigger which stops the Insert. When I disable the trigger everything is fine.

I know it: Triggers can be both a friend or foe :o)

Regards, Filip

January 21, 2015
9:00 pm
Henk Helmantel
Admin
Forum Posts: 553
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Filip,

There is no reason why flash messages should not be stored in the 'MessageIn' table of the SQL database. Flash messages are normal SMS messages in Diafaan SMS Server, they just have a different message type. On some GSM modems, flash messages are handled differently from other messages and sometimes cannot be read out properly form the SIM card but that does not seem to be the case here.

Do you see any error messages in the event log of the SQL Connector or of the GSM Modem Gateway that receives the flash message that could be related to the problem?

Regards, Henk

January 21, 2015
3:32 pm
Filip
Guest
Guests

Hi

I have an issue with receiving Flash SMS to the MessageIn table for the SQL Connector. Ordinary Text SMS is recieved to the table without problems, but not Flash SMS. They only appear in the Receive Log. Is there a way to save all received SMS types to MessageIn or do I have an error i my setup?

Regards Filip Højbak, Denmark

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
8 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 364

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 532

Posts: 1847

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 553