Hi, that's perfect. It's working.
I need to work with SPs to generate the SMS content, using the client's information.
Thanks. I will be testing it before buying.
I am not entirely sure how you would use a stored procedure in SQL Server to generate the SMS messages. In general, you only have to fill the MessageTo and MessageText fields of the MessageOut database table. Diafaan SMS Server then reads the records from the table, removes the records and sends the messages. The MessageLog table is used by Diafaan SMS Server to log the sent or failed SMS messages, it should not be used to insert your own messages.
A minimal SQL query to send an SMS message is:
INSERT INTO MessageOut
'300, Error: No active SMS gateway available to send this message.'
means that Diafaan SMS Server is not able to route the message to one of the gateways. It is possible that you have no gateway defined for the SQL Connector, the gateway(s) may not be available or you have another routing filter enabled that prevents a valid route of the message to one of the gateways.
Hello, I need to load the [MessageOut] table, using a stored procedure in SQL SERVER.
I was trying to use something like:
INSERT INTO MessageLog
VALUES (getdate(),'','+54115377xxxx','test 4',
But It's not working, I don't know how to complete the MessagePDU field, on the logs I see:
300, Error: No active SMS gateway available to send this message.
is there any way to load de messageout table? I don't want to use http, c#, vbnet. just a simple stored procedure. I need to send aprox 10.000 sms every day per simcard.
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 491
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 917