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

Tim King tim at compnetwork.net
Thu Sep 22 09:52:07 MST 2005


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. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050922/e44c9fff/attachment.htm


More information about the asterisk-users mailing list