[Asterisk-Users] AGI Script to interact with ACCESS Databse and Set CID info on the fly.

[Tom Hayden]

If you used a perl or PHP agi script, you could probably use some kind
of ODBC drivers to communicate between the two.

--
Tom Hayden

On 9/22/05, Tim King <tim at compnetwork.net> wrote:
>
>
>
> Well guys here comes the fun part. I have a Microsoft access (VBA)
> application that interfaces with my SQL database. This app pulls of info
> from the SQL record and than picks up the phone and dials that locations
> number. I have purchased a few hundred NpaNxx's for my own use. I want get
> into too much detail there but no worries this is legal. I need to change my
> CID info on the fly. So I am thinking it should be easy to make an AGI
> script that just sets the CID info on a particular line using two variables
> being passed to it $Line_No to tell it what line to set and than $CID to be
> the number to set on that extension for that call. It also should be
> relatively simple to have the access app take a look at the area code and
> phone number for the location being called and pull a phone number from the
> NUMBERS table which has all of my numbers in it and pass that over. The real
> question is how do we get Access to speak to an AGI script. Has anyone done
> anything like this? Thanks a lot for reading but this will be a fun one.
> _______________________________________________
> --Bandwidth and Colocation sponsored by Easynews.com --
>
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>
> http://lists.digium.com/mailman/listinfo/asterisk-users
>
>


--
Tom