similar to: Executing Stored Procedure using ODBC MSSQL

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

I'm trying to use func_odbc to write to a MS SQL db. Here's my func_odbc conf: [OPTIN] dsn=MSSQL-Optin write=INSERT into OptIn (orgID) values (${VAL1}) Dial Plan exten => +18665551212,n,Set(ODBC_OPTIN()=dave) When I do an odbc show, it shows that I am connected to the db. If I use isql, I can write to the db, however, when I use func_odbc, a record will not write. I'm using

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

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

?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, Does asterisk func odbc support multi query? I'm executing stored procedure which returns two tables. With tsql command I can see both tables. But asterisk only shows the first. My database is MSSQL. Maybe there is workaround... Thanks -- Best Regards, Giedrius -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi all, I am testing with Asterisk 1.8.0 beta3 using realtime with a mssql server using freetds and unixodbc, which works with 1.6.1.20. With the same config in 1.8 I get an error when trying to start asterisk which says: [Aug 23 15:06:12] WARNING[7180]: loader.c:387 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined

I have a mixed PBX system with both Asterisk 1.4.21 and 1.2.27 (moving to 1.2.28). For now I need to keep a few boxes in 1.2 and not migrate them all to 1.4. However, I would like to have func_odbc and res_odbc on all servers. On 1.4.21, native func_odbc seems to work fine. On 1.2.27, the func_odbc backport is giving me an error (I know that this backport is not "officially supported"

Hello I am having trouble setting up the cdr_odbc with MSSQL server. Has anybody done this? I have followed what little documentation I can find. Asterisk errors on a connection error, but tcpdump doesn't even show an attempt. Does anybody have some examples for MSSQL ODBC CDR? I've downloaded unixODBC and the FreeTDS project, recompiled asterisk.... Thanks Duane Cox --------------

Hi, I have some issue with voice mail with ODBC on asterisk 11.7 box. I may not understand database functionality on asterisk fully. The most suspected area is func_odbc. I already googled but not luck. Your guide is warmly welcomed *Error messages when I make call and leave message.* -- <SIP/1ffa9-00000007> Playing 'auth-thankyou.g722' (language 'en') [2014-05-28

Dear List, I have an asterisk 1.6.2 installation. I'm trying to configure func_odbc to read some mysql tables... but every time I tried I got this message: ERROR[24968] func_odbc.c: Unable to execute query [SELECT bloqueada FROM funciones WHERE extension='750'] I'm sure the DSN is right because I can do this: [root at grupodelavega asterisk]# su - asterisk [asterisk at

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!!!

Dear Master I am new comer in this mailing list. Can you tell me how to connect BDE and ODBC for MSSQL connection using wine. I have already install BDE from Delphi 5 and DBCrab from Winetools. ODBC is OK to connect MS SQL database. But when I joint with BDE using ODBC to connect database there is some error like : [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or

Hello, running plain samba 3.023c on debian, I'm trying to connect to a samba share from within a stored procedure. This works as long as samba is in "share" mode: [2006/09/29 14:53:01, 5] auth/auth.c:check_ntlm_password(309) check_ntlm_password: guest authentication for user [] -> [] -> [nobody] succeeded When I try to attach samba share manually when logged in as the

Hi, I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage (FreeTDS -> Mssql 2008 database). Everything it's working fine, but sometimes I receive this error and Asterisk crashes. [Aug 25 13:25:13] WARNING[14032] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk /voicemail/default/7002/INBOX'] [Aug 25

I am running CentOS 5 with Asterisk 1.4.14. I am trying to setup storage of voicemail messages into MySQL. It is my understanding that I can only do this via ODBC. I installed per http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to

[Reposted now I've joined the list, so I hopefully don't get moderated out] Hi, I've upgraded lots of machines to 5.6 (thanks!) and there was one particular machine that I'd also like to upgrade to PHP 5.3. Unfortunately it seems I can't. On the machine I have php-mssql installed, and it appears that there is no php53-mssql. php-mssql is built from the php-extras SRPM, so

Hi all, I''m trying to get rails up on mssql for a friend, does anyone have experience? We''re working on a Windows XP box with MSSQL 2000 (no service pak), and both rails (1.1) and MSSQL are on the same box. I''m running into a bug (I think) where activerecord is using this syntax: SELECT TOP 1 * FROM users WHERE (users.user = ''jbgnuumnbu'')

Hi, I have an app with Delphi7 + MSSQL, developed during 10 years. Now, the users have asked me about some way to run this app into Linux Fedora Core 2/3. I use Fedora for apps in Java with no problems, but I never heard about Delphi run. I look at WineHQ site about this combination of Delphi + MSSQL but I didn't find. I found some thing about Delphi 7 install and slow behaviour in

I have downloaded the php5 rpms from Centos and successfully am running them on RHEL4. However, there is no rpm for php-mssql. Has anyone created one that could be installed on RHEL4? Thanks. - Mark