Hi Carl, In addition to what was stated below, you will need to configure ODBC on the operating system. So in other words, to get Asterisk to start talking to ODBC, you need to configure 4 things: 1. /etc/odbcinst.ini needs to be configured. This depends on your OS and which database type your are connecting to. 2. /etc/odbc.ini needs to be configured and (I think) it is the file that provides a DSN. 3. As per below, setup /etc/asterisk/res_odbc.conf 4. Put your functions in func_odbc.conf remembering to tie it back to the DSN setup in /etc/asterisk/res_odbc.conf.
This is from memory so forgive me if I have said something that is wrong. Kind Regards Stuart Elvish 2009/5/15 carl Lougher <c_loug...@yahoo.co.uk>: > > Thanks. > > --- On Thu, 14/5/09, Tilghman Lesher <tilgh...@mail.jeffandtilghman.com> > wrote: > >> From: Tilghman Lesher <tilgh...@mail.jeffandtilghman.com> >> Subject: Re: [asterisk-users] Help need to do Lookup from odbc database >> To: "Asterisk Users Mailing List - Non-Commercial Discussion" >> <asterisk-users@lists.digium.com> >> Date: Thursday, 14 May, 2009, 4:20 AM >> On Wednesday 13 May 2009 17:55:41 >> carl Lougher wrote: >> > Howdy, >> > How do i perform a lookup from a remote odbc database >> in the asterisk >> > dialplan? >> > >> > I can do it with mysql but not sure of commands for >> odbc connection. >> >> See func_odbc.conf for examples. You'll also need to >> setup res_odbc.conf, as >> this is where func_odbc obtains its handles. >> >> -- >> Tilghman >> >> _______________________________________________ >> -- Bandwidth and Colocation Provided by http://www.api-digital.com -- >> >> asterisk-users mailing list >> To UNSUBSCRIBE or update options visit: >> http://lists.digium.com/mailman/listinfo/asterisk-users >> > > > > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > Stuart Elvish (dCAP) www.stuartelvish.com Telephone 03 8888 5361 (+61 3 8888 5361) Mobile 0408 873 601 (+61 408 873 601) Facsimile 03 9018 4304 (+61 3 9018 4304) Email stuart.elv...@stuartelvish.com Visit www.stuartelvish.com for simple, seamless, smart solutions. Australia 03 8888 5361 United Kingdom 0844 774 2922 United States 1888 2999 117 Canada 1888 2999 117 _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users