similar to: Asterisk Realtime unixODBC timeout?

maybe someone here can help me understand why I am getting this strange behaivor. I am connecting to a MS SQL server from PHP by the ODBC module, I use unixODBC-2.2.9-1, freetds-0.63-1.2.el4.rf and php-4.3.9-3.9 all but the freetds package came with CentOS-4.2 + updates the problem is that I am getting -1 from the odbc_num_rows(); function, I search the net and it looks that this is a very

Hi all, I am getting a problem in calling Stored Procedure from C++ application on macintosh using OpenLink. Exact scenario is that my stored procedure takes 6 parameters out of which 1 parameter is out parameter and other 5 are input parameters. So it uses 5 IN parameters as values for inserting a row in database and returns its max id as out parameter. Code Snippet is given below :--

I would like some Asterisk community input: It was requested of me to create an Asterisk FreeTDS (cdr_tds.c) module to allow Asterisk to populate MS SQL Server (and Sybase) with CDR records. unixODBC has been thrown around as a bright shiny button but it adds an additional layer of DB abstraction. That additional layer of abstraction can cause problems when it is not necessary for our TDS (MS

Hello, I have configured Wine in Ubuntu 9.04 to use the built-in odbc32.dll which in turn uses the Linux's unixodbc package. When I am trying to run my windows application which actually uses Windows API connecting to Unix ODBC is not working. The API uses is SQLDriverConnect (), that returns me error [unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so' file not

Hello. It's possible to use IODBC instead UNIXODBC with realtime? As I see, the res Makefile load a odbcinst.h file, but in IODBC there's not this file. I change the res Makefile (iodbcinst.h instead odbcinst.h) and the make create the res_odbc.so. But when asterisk boot it don't start showing: [res_odbc.so]Oct 4 10:24:43 WARNING[9748]: loader.c:314 __load_resource: libiodbc.so.2:

Hello, I decided to embrace getting a new Rails application to see an existing MSSQL database and trying to get unixODBC, freeTDS, and ActiveRecord able to query my MSSQL database. I''m following the procedure outlined at http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7)

Kia ora, As many of you are aware (and for those who aren't) as part of Asterisk 13.8 changes went into the res_odbc module to more heavily leverage UnixODBC connection management and pooling capabilities. Previously we would use only a single connection to the database. Since this has been released many individuals have reported crashes and apparent deadlocks as a result of this change.

Hi, I have Asterisk 12.7.1 installed through Asterisk@Home CD. and explicitly I have installed UnixODBC and FREETDS in order to access MS SQL 2000 Database which in on Windows 2003 Server on remote location. I tested connectivity through isql and tsql, both utilities are working fine. I need to access MS SQL 2000 Database through PHP. When I tired to check the connectivity through a Test PHP

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

Just in case anyone with FC4 and maybe other distros were trying to use unixODBC-2.2.11 and wine's built in odbc32. If your app errors out when you issue a query with an undefined symbol of __post_internal_error you will need to use an early snapshot of the 2.2.12 unixODBC that resolves this issue... Nick Gorham wrote: > Adam Gibson wrote: > >> Using freetds-0.63-1.2.fc4.rf

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

I have Asterisk 1.4.32 and I would like save all VoiceMail to MSSQL 2008 database. I configured ODBC, but I receive this errors. [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: Connecting sqlserver [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] [Jun 18 14:00:37] WARNING[19914] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail

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

Both of our production asterisk servers are dumping core when making writes to our cdr tables. Here is a backtrace of the problems we are having: #0 0x00447b1f in tdserror (tds_ctx=0x1, tds=0xb7938c90, msgno=20004, errnum=9) at util.c:347 347 if (tds_ctx && tds_ctx->err_handler) { (gdb) bt #0 0x00447b1f in tdserror (tds_ctx=0x1, tds=0xb7938c90, msgno=20004, errnum=9) at

Hello Everyone, I have an installation where the client has a Microsoft SQL database that holds all of their case information. They would like the asterisk system to require users to enter a valid case number when making an outgoing call. I?m seeing some documentation regarding people using Microsoft SQL for CDR storage, however nothing regarding validating authentication using a Microsoft SQL

I have a project that is requiring the use of MS SQL from asterisk. I get an error when the pjsip contact tries to update the contact table. [Oct 15 21:34:55] WARNING[3033]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 22018: [FreeTDS][SQL Server]Conversion failed when converting the varchar value '3.000000' to data type int. (101) The datatype

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

Hi all, I'm new to asterisk. I have it installed and 1 x100p card. I'm trying to use kphone to connect out. But, when I start * it gives me sound card busy error. I've checked ps aux and nothing seems to have the sound card. Any ideas? Does starting asterisk automatically take the sound card? Also, can you use the phone connected into the XFO card w/ asterisk or do you need an XFS card

Hi, is cdr logging using odbc buggy? I'im only getting an error "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". Connecting with isql to the datasource given in cdr_odbc.conf works just fine, and using the database for sippeers also works. The documentation[1] is confusing because it says freeTDS is required and that you must not use multiple

Hi all I have a strange issue with 1.8.11.0 on a production Asterisk machine at our head office, and the same issue with a production machine at a branch office. Every now and then, on the head office machine, ODBC CEL and CDR logging will stop working. On examination in the CLI, Asterisk behaves as if the config files for ODBC in the /etc directory are just gone. Repeated tests have then