David wrote: > When I do an odbc show, it shows that I am connected to the db. If I use > isql, I can write to the db, however, when I use func_odbc, a record will not > write. I'm using asterisk 1.4.9. Any idea what might be wrong?
Sounds sneakingly like a permissions problem in your database for the login account that you are using through ODBC. But if not, the INSERT SQL statement may not be correctly established for your database. Personally I don't use ODBC for this sort of thing. Its not really a 'Linux' type thing, and relies on a lot of middle-ware layers between the Asterisk server and the database. Not that you have too many choices, but what we do that works brilliantly well here is to use PHP-AGI to construct a PHP script that does all the DB connection, inserting, etc. and just have the Asterisk dialplan call that. This way I have total visibility to the SQL and I have apply some transforms to the data in PHP if needed. It also means that if I want to swap out the DB to another brand, I can do that with only one place to change the code. FWIW... Myles -- ======================= Myles Wakeham Director of Engineering Tech Solutions USA, Inc. Scottsdale, Arizona USA http://www.techsolusa.com Phone +1-480-451-7440 _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
