[Asterisk-Users] Database lookups?

[Josiah Bryan]

On Thursday 07 April 2005 3:19 pm, Jan Johansson wrote:
> Is it possible (How complicated is it?) to do this;
>
> Call comes in, connects to IVR
>
> IVR plays the usual "please type your order number, finish with pound"
>
> Then I would like to query a MSSQL database server, looking up the "Status"
> column from a row where ordernr = the entered order number.
>
> Depending on the result of the lookup, play one of two messages  ("Yes,
> ready for pickup" or "No, your order is not ready").
>
> Can someone clue me in on which docs I should start with? Or is there an
> example of this somewhere?

Very simple. AGI. Write a custom AGI program (any language) to do the MSSQL 
query. AGI can control playback of audio, etc. See 
http://www.voip-info.org/wiki-Asterisk+AGI.

Cheers & HTH -
-josiah

-- 
Josiah Bryan
IT Coordinator
Productive Concepts, Inc.
jbryan at productiveconcepts.com
(765) 964-6009, ext. 224