I've got an Asterisk switch that is going to run an IVR menu with a database interface that will be doing lookups based on the user entered data and then reading back strings with the appropriate data integrated into the text. I have found quite a bit of data on using MySQL as a database with Asterisk, but I haven't found much about using MS SQL Server with Asterisk... We have a SQL Server 2005 database server that has all the data that is needed for the IVR interface, and it would be great if we could interface directly with it using Asterisk. Does anyone have any suggestions on even attepting this? Another option might be to setup Asterisk to interface with MySQL and then work out the details of exchanging data between MySQL and SQL Server... Any and all help is greatly appreciated!! -Larry -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070904/45b2f28a/attachment.htm
You can use Asterisk's AGI and PHP/Perl or whatever else. You'll need to install connecting software, such as FreeTDS, to connect to SQL. Then you can either pass arguments to your script or use environment variables to set Asterisk variables. Here's a good place to start: http://www.voip-info.org/wiki-Asterisk+AGI Larry Costigan wrote:> I've got an Asterisk switch that is going to run an IVR menu with a > database interface that will be doing lookups based on the user entered > data and then reading back strings with the appropriate data integrated > into the text. I have found quite a bit of data on using MySQL as a > database with Asterisk, but I haven't found much about using MS SQL > Server with Asterisk... > > We have a SQL Server 2005 database server that has all the data that is > needed for the IVR interface, and it would be great if we could > interface directly with it using Asterisk. Does anyone have any > suggestions on even attepting this? > > Another option might be to setup Asterisk to interface with MySQL and > then work out the details of exchanging data between MySQL and SQL > Server... > > Any and all help is greatly appreciated!! > > -Larry > > > ------------------------------------------------------------------------ > > _______________________________________________ > --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
On 9/4/07, Larry Costigan <larry.costigan at gmail.com> wrote:> I've got an Asterisk switch that is going to run an IVR menu with a database > interface that will be doing lookups based on the user entered data and then > reading back strings with the appropriate data integrated into the text. I > have found quite a bit of data on using MySQL as a database with Asterisk, > but I haven't found much about using MS SQL Server with Asterisk... > > We have a SQL Server 2005 database server that has all the data that is > needed for the IVR interface, and it would be great if we could interface > directly with it using Asterisk. Does anyone have any suggestions on even > attepting this? > > Another option might be to setup Asterisk to interface with MySQL and then > work out the details of exchanging data between MySQL and SQL Server... > > Any and all help is greatly appreciated!! >You'll want to take a look at func_odbc which should probably give you a pretty good conduit to get the data you need to work through the IVR flow. -- Bird's The Word Technologies, Inc. http://www.btwtech.com/