similar to: func odbc and mult iquery

Hi all, I'm trying to set up an odbc connection to a ms-sql server from an asterisk 1.6.1 install My problem is that I cannot get asterisk to build func_odbc & res_odbc.so I installed yum -y install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel And then went on to reconfigure / recompile asterisk after a ./configure --with-odbc=/usr/lib/ I get

Hello, I'm working with asterisk 1.6. And I have success using func_odbc with one row query results (SELECT source,destination from cc WHERE ... ): exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(ARRAY(NUMBER,REALNUMBER1,REALNUMBER2,STATUSAS)=${ODBC_GETVARIABLES(${NUMERIS})}) exten => s,n,Verbose(1| ${NUMERIS}, ${REALNUMBER1} ${REALNUMBER1},

Hello, Now I'm testing func_odbc and hash. My configurations are: func_odbc.conf [GETNUMBER] dsn=sqlserver ;mode=multirow ;rowlimit=10 readsql=SELECT number,real_number1,real_number2,status FROM ivr.dbo.numbers WHERE number=${SQL_ESC(${ARG1})} extensions.conf exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(NUMERIS=37037210602) exten =>

Hi All Anyone know how to do include files with func_odbc.conf? I now have several pages of functions in my func_odbc.conf and it is getting harder to maintain it. I would like to break them up into files by category. The standard method of using the #include does not seem to work . Ideas are appreciated. Bryant -------------- next part -------------- An HTML attachment was

All, Thank you in advance for any help. I have a customer in need of a conferencing system. A requirement is for users to each have their own PIN for the same bridge. So, I put the list of users, PINs bridges into a MYSQL DB and used an ODBC connector to parse the table. Asterisk is connected and reads the rows as expected. The problem is that if a user enters a PIN that is NOT in the table,

Hello all, I am trying to connect to my remote MS SQL server from Ubuntu. I have followed HowtoConnectToMicrosoftSQLServerFromRailsOnLinux<http://http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux>as best that I can. TSQL is working, example below. My configs are found below. When I run isql : > isql -v pubs name password [IM002][unixODBC][Driver

Hi guys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY

Hello all! My basic problem is that we haven't been able to get realtime to use ODBC to store configuration data. Here are the details: We've installed Asterisk on a CentOS machine as follows: 1. Downloaded, compiled, and installed FreeTDS 0.63 2. Downloaded, compiled, and installed unixODBC 2.2.11 3. Downloaded, compiled, and installed Asterisk, Asterisk-Addons, and Zaptel from CVS

Howdy, How do i perform a lookup from a remote odbc database in the asterisk dialplan? I can do it with mysql but not sure of commands for odbc connection. Cheers!!!

hello, I've callcenter and our queue members want to see on their IP phone's display queue's name , from which incoming call was originated, for example "<client's_number> -> Sales". This problem appears when one member can belong to couple queues. Work around would be setting calling name with such information. Maybe there is another way (setting SIP

?Many people are reporting the same issue, so it is not my imagination. Asterisk 13 above 13.1 is useless for anybody who ?relies on res_odbc.so. As you know, after that version, the dropped the complexity of Pooling onto unix_odbc itself. Not so simple, it seems. I noticed that after a few hours of inactivity, any call to func_odbc-defined funcions will block and hang for ever. All we can do at

Hello, I have asterisk 1.6.0.20 and Is it possible to add Reason header on Hangup: Reason: q.850;cause=17 Thanks -- Best Regards, Giedrius -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100221/d29c02b8/attachment.htm

Hello, Is it possible use asterisk curl function with ssl sertificate? Thanks -- Best Regards, Giedrius -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100225/37ceb99e/attachment.htm

Hey :) We''re doing this large project, based on a legacy MSSQL database. We''ve had some issues, particularly with datetimes, when communicating with the server. These issues dissapeared after updating our ruby-odbc package to a new version (we''re developing on Linux and MacOS X, and connecting to the remote MSSQL server via FreeTDS and UnixODBC/iODBC, and then ruby-odbc

Hi: I need help merging rows. I am trying to merge the 'Month' column using \multirow. For example for the column 'Week' I want July to be merged into one row(weeks 27,28,29,30) and so on for the following weeks. Below, I am creating a PDF using Sweave, MikTex,R-2.8.1 and windows XP to show an example. \documentclass[11pt]{article} \usepackage{longtable,verbatim} \title{How to

I've successfully connected to my SQL server with tsql (freetds) and isql (unixodbc). I've followed the wiki, and everytime I try and run * shutdowns with a segmentation fault. Any help? Luke Catranis

Hi all, I have a series of measurements made over different types of road surfaces and capacity that I want to summarize in tables via LaTeX. Ideally I'd like a table similar to this ( http://www.andy-roberts.net/misc/latex/tutorial4/multirow.png ) with mean/SD of the measurement broken down by road type (both surface and capacity). Ideally it would be extensible so that when I add layers

Hello, I'm trying to execute a stored procedure on a MSSQL Server from the dial plan, but it's not working. I'm getting the following error: Unable to execute query.... Asterisk has been compiled with UnixODBC, and I've done the necessary configurations in func_odbc, res_odbc and odbc.ini. Has anyone done this before with success? -------------- next part -------------- An HTML

Hi all, The asterisk book states the following for using ODBC to connect to an MS database. ? The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you to establish multiple connections (up to limit connections) to a database while ensuring that each connection has only one statement executing at once (this is due to a limitation in the protocol

svn trunk. I'm trying to get cdr to work with my odbc database. I have followed a checklist that I had previously but still can't get it to work. There are no errors (verbose 40 and debug 40), I get [cdr_odbc.so] => (ODBC CDR Backend) == Parsing '/etc/asterisk/cdr_odbc.conf': Found *CLI> cdr status CDR logging: enabled CDR mode: simple CDR registered backend: