[asterisk-users] Asterisk & M$ SQL Server

[Julian Lyndon-Smith]

Func_odbc is your friend.

Check out func_odbc.conf for odbc access from the dialplan
Check out res_odbc.conf to allow you to use odbc as a realtime source

Julian.

Callum McGillivray wrote:
> I was hoping for something more along the lines of the Asterisk CMD 
> MySQL().
> 
> I could always resort to something like that.. but I don't want to "run" 
> it on a windows server and I really don't want to go to the bother of 
> writing FastAGI scripts to make it all happen.
> 
> I just want to write a quick and dirty DB lookup so that I can rewrite 
> the CLI before passing the call along.
> 
> mitcheloc wrote:
>> Oh. Got it now. Well, in this case I think you are looking at it
>> backwards. I imagine most users with this requirement write AGI
>> scripts that talk to their databases then communicate back. You can
>> use FastAGI and run your code on a windows server, or you could use
>> any other programming language (PHP, MONO) to acheive the same, but
>> then place it locally on the Asterisk side.
>>
>> On 4/22/07, Callum McGillivray <callummc at ains.net.au> wrote:
>>> Oh.... Microsoft SQL Server for those unfamiliar with the term M$ ;)
>>>
>>> mitcheloc wrote:
>>> > I've never heard of M$ SQL Server?
>>> >
>>> > On 4/22/07, Callum McGillivray <callummc at 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
>>> >>
>>> > _______________________________________________
>>> > --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
>>>
>>> _______________________________________________
>>> --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
>>>
>>
>>
> 
> _______________________________________________
> --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
> 
> ______________________________________________________________________
> This email for dotr.com has been scanned by MessageLabs
> ______________________________________________________________________
> 
>