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. >
IN Asterisk 1.4 you could use func_odbc. I guess this will work as well with mssql as with postgresql, which is quite satisfactory. Also, with cdr_odbc you could store cdr records in you database. > 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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. >>> >> -- Remco Post "I didn't write all this code, and I can't even pretend that all of it makes sense." -- Glen Hattrup _______________________________________________ --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