similar to: Asterisk and FreeTDS 0.64 or >0.63

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, I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from sources. I installed freetds-common,freetds-dev, libct4, libsybdb5, freetds-bin, but, when I run configure and then make menuconfig in section "Call Detail Recording" -> "cdr_tds" it's "disabled". It only writes that "Depends on: freetds(E)". On another server (same

I'm trying to use freetds/odbc to write CDR records to a MSSQL database but when I installed them and tried to compile asterisk again I get: _tds.c cdr_tds.c: In function `mssql_connect': cdr_tds.c:415: `TDSCONNECTINFO' undeclared (first use in this function) cdr_tds.c:415: (Each undeclared identifier is reported only once cdr_tds.c:415: for each function it appears in.)

Hi all, I have a working 1.0.7 installation and it is recording CDR to mysql. I am using FreeTDS on the system currently to access our MS SQL 2000 server for account verification, we may use it to store CDR records there in the future. I have decided to update the installation to 1.0.9. However, during "make", I receive: make[1]: Entering directory `/usr/src/asterisk/cdr' gcc

Hi, I'm trying to install FreeTDS. I followed the instructions on http://www.voip-info.org/tiki-index.php?page=FreeTDS, but still can't get it to work. I serched around trying to find instructions on it, and it seems the same info (even wording) appear on all sites I found. I downloaded freetds-0.63, and followed the instructions step by step, and when I try to re-compile Asterisk (#make

Hi All I have an Asterisk 1.8.32.3 instance that will at random intervals stop logging CDR data to MSSQL via FreeTDS. On investigation I'll find that the FreeTDS module has been unloaded somehow. It is not listed in cdr show status or show module like. Trying module load cdr_tds results in module cdr_tds does not provide a license key and the module is not loaded. The only way to get

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

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, guys! I'm trying to use php-mssql and I've tested the same php program on two servers (CEntOS-5 and Debian). CEntOS-5.2 (final) - php 5.1.6-20 - php-mssql 5.1.6-15 (from "extras" repository). - freetds 0.64-11 --------------------------- php test code -------------------------------- <?php ini_set('display_errors',1); error_reporting(E_ALL);

Hello -- What repository, or other website, can I access in order to get the latest version of freetds? The version that comes with centos 6.2 is the 0.64 release, and it has a bug in it that is preventing me from running another application. The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the

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)

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

Hi there ! I''m drilling for some framework/apserver solution and come to RoR. After using InstantRails, I would try to run it on my test platform (Solarix 10 x86 on 1 machine, Sybase ASE on another, FreeTDS for the join). I could not manage to have the sybase driver for ruby compile with FreeTDS. So I try to run a ODBC bridge. All seems good (freeTDS runnin, unixODBC working with

If I fire up asterisk it connects to my MSSQL server via ODBC just fine. However, if I issue a reload it unloads the ODBC.. then loads it again and I get an error... and keep getting it until I On a fresh start: Aug 26 15:43:14 WARNING[13818] cdr_odbc.c: cdr_odbc: table not specified. Assuming cdr Aug 26 15:43:14 VERBOSE[13818] logger.c: -- cdr_odbc: dsn is MSSQL-asterisk Aug 26 15:43:14

Hi there ! After writing up a little adapter to access my sybase server, using odbc/dbi/freetds/unixodbc (yes all of these), it''s now time to have a *real* adapter, not running through to-many-to-count layers. I plan to use the FreeTDS library rather than Sybase because of the availability of FreeTDS for windows os. Is there already a work in progress for this kind of stuff ? Are

I''m having an error from Linux via freeTDS/ODBC to SQL Server with cod that runs fine against SQLite and MySQL. Here''s the code: def find_recipes_for_workorder_by_id @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :conditions => ["recipe.workorder_id = ?", params [:workorder]] render :template =>

Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES

Anyone know of a repository with the current - 1.0 - version of FreeTDS? ? The packaged version 0.91 from EPEL is considerably out of data. -- Meetings Coordinator, Michigan Association of Railroad Passengers 537 Shirley St NE Grand Rapids, MI 49503-1754 Phone: 616.581.8010 E-mail: awilliam at whitemice.org GPG#D95ED383 Web: http://www.marp.org

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

Hello Dear experts, I am new to Ruby on Rails. Though I want to access to MSSQL 2005 from ruby. I installed tiny_tds using following commands: >sudo apt-get install freetds-dev >gem install tiny_tds And now when I executed @client = TinyTds::Client.new( :username => ''username'', :password => ''password'', :host =>