[asterisk-users] MS-SQL / Freetds -- func_odbc

[Tilghman Lesher]

On Thursday 21 October 2010 19:16:16 Neeraj Chand wrote:
> How would I go about running a stored procedure call from asterisk via
> func_odbc.

Check an ODBC reference to be sure, but the template would probably
be somewhere along the lines of:
readsql={ CALL sp_foo(${ARG1}) }

http://msdn.microsoft.com/en-us/library/ms403294.aspx

> I'm after an example entry in func_odbc if possible for ast 1.4
> 
> Also, if someone could post an insert statement that actually works,
> would be nice.

writesql=INSERT INTO foo (bar) VALUES ('${VAL1}')

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org