[asterisk-users] Help need to do Lookup from odbc database

[Stuart Elvish]

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_lougher at yahoo.co.uk>:
>
> Thanks.
>
> --- On Thu, 14/5/09, Tilghman Lesher <tilghman at mail.jeffandtilghman.com> wrote:
>
>> From: Tilghman Lesher <tilghman at 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 at 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.elvish at 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