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 <[email protected]>wrote: > 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=%p&text=%r"; > > But how to tell Kannel to read and update MTs? > > Thanks in advance > >
