Re: Kannel with SQL-Server SMS Spool
Thanks Alejandro for your time :) I'm going to give it a try. 2011/1/12 Alejandro Guerrieri alejandro.guerri...@gmail.com Santiago, You'd need to modify sqlbox's queries to call stored procedures instead. They're defined on macros on sqlbox_mssql.h You'll probably need to tweak the code for the responses to match what your stored procedure returns. Hope it helps. Alejandro On Wed, Jan 12, 2011 at 4:37 PM, Santiago Cattaneo santia...@gmail.comwrote: Hello all, I new to Kannel and I'm trying to set it up on this way: 1. Connect to several SMPP gateways (no problem) 2. Insert MT and MO messages on a SQL-Server Spool Database (problem!!!) I tried SQLBOX and it works very well, but, I need to use a Stored Procedure interface to access to the SQL-Server. (One SP for SELECT MT, one for UPDATE MT sent and one for INSERT MO). I wondering if it is possible to do that, I think maybe could use sms-service like this for INSERT MO: group = sms-service keyword = nop get-url = http://host/service?sender=%ptext=%r; But how to tell Kannel to read and update MTs? Thanks in advance
Kannel with SQL-Server SMS Spool
Hello all, I new to Kannel and I'm trying to set it up on this way: 1. Connect to several SMPP gateways (no problem) 2. Insert MT and MO messages on a SQL-Server Spool Database (problem!!!) I tried SQLBOX and it works very well, but, I need to use a Stored Procedure interface to access to the SQL-Server. (One SP for SELECT MT, one for UPDATE MT sent and one for INSERT MO). I wondering if it is possible to do that, I think maybe could use sms-service like this for INSERT MO: group = sms-service keyword = nop get-url = http://host/service?sender=%ptext=%r; But how to tell Kannel to read and update MTs? Thanks in advance
Re: Kannel with SQL-Server SMS Spool
Santiago, You'd need to modify sqlbox's queries to call stored procedures instead. They're defined on macros on sqlbox_mssql.h You'll probably need to tweak the code for the responses to match what your stored procedure returns. Hope it helps. Alejandro On Wed, Jan 12, 2011 at 4:37 PM, Santiago Cattaneo santia...@gmail.comwrote: Hello all, I new to Kannel and I'm trying to set it up on this way: 1. Connect to several SMPP gateways (no problem) 2. Insert MT and MO messages on a SQL-Server Spool Database (problem!!!) I tried SQLBOX and it works very well, but, I need to use a Stored Procedure interface to access to the SQL-Server. (One SP for SELECT MT, one for UPDATE MT sent and one for INSERT MO). I wondering if it is possible to do that, I think maybe could use sms-service like this for INSERT MO: group = sms-service keyword = nop get-url = http://host/service?sender=%ptext=%r; But how to tell Kannel to read and update MTs? Thanks in advance