[asterisk-users] Asterisk w/MS SQL Server 2005

[Mik Cheez]

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