Support forum

sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
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
Go to Top
4sp_Permalink sp_Print sp_QuotePost Quote

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
Go to Top
3sp_Permalink sp_Print sp_QuotePost Quote

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: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_EditHistory sp_Permalink sp_Print sp_QuotePost Quote

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
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

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

sp_NewPost Add Reply sp_NewTopic Add Topic
Go to top
Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
6 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488