Hi all, Has anyone successfully set up asterisk to query a M$ SQL Server? I'd like to be able to query one in the dial plan and use the results to tamper with call priorities / CLID etc. If someone could point me to a howto / guide or relate their experiences with this, that would be great ! Thanking you all in advance. Callum P.S. Before anyone asks; it's a legacy database that has to be kept on SQL Server for other business reasons.
Try the A$teri$k user'$ li$t. On 4/22/07, Callum McGillivray <callummc@ains.net.au> wrote:> > Hi all, > > Has anyone successfully set up asterisk to query a M$ SQL Server? > > I'd like to be able to query one in the dial plan and use the results to > tamper with call priorities / CLID etc. > > If someone could point me to a howto / guide or relate their experiences > with this, that would be great ! > > Thanking you all in advance. > > Callum > > P.S. Before anyone asks; it's a legacy database that has to be kept on > SQL Server for other business reasons. > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070422/5e3325f1/attachment.htm
I've never heard of M$ SQL Server? On 4/22/07, Callum McGillivray <callummc@ains.net.au> wrote:> Hi all, > > Has anyone successfully set up asterisk to query a M$ SQL Server? > > I'd like to be able to query one in the dial plan and use the results to > tamper with call priorities / CLID etc. > > If someone could point me to a howto / guide or relate their experiences > with this, that would be great ! > > Thanking you all in advance. > > Callum > > P.S. Before anyone asks; it's a legacy database that has to be kept on > SQL Server for other business reasons. > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
FreeTDS is another option. Thanks, Steve Totaro http://www.asteriskhelpdesk.com KB3OPB _____ From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Matt Sent: Tuesday, April 24, 2007 8:45 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Asterisk & M$ SQL Server We use it extensively for many things. You'll need freeodbc to connect to M$ $QL $erver.... but Asterisk will happily talk. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070424/377c6f74/attachment-0001.htm