similar to: CDR_TDS tries to write to ends column instead of end

Hi all <high embarrassment factor> Managed to solve this. It wasn't Asterisk's fault, I had a trigger on the ast_cdr table which was referrening to another table in my DB having an "ends" column, when it should have been "end". cdr_tds was literally just passing along the error it got from "deeper" in the MSSQL table structure I'm using with

I am trying to get * to write CDR records to an MS SQL table. I am used the freeTDS set up (not using UNIX ODBC), and it appears to be making the connection to the database, but I make a call, I get this error: WARNING[3369]: cdr_tds.c:180 tds_log: Reconnected to SQL database. ERROR[3369]: cdr_tds.c:191 tds_log: Failed to insert Call Data Records into SQL database. I've assigned all rights

I have installed Asterisk with FreeTDS many times before (this same Asterisk and same TDS version)... but today when I did the make it gave me this error: ake[1]: Entering directory `/home/matth/asterisk126/asterisk-1.2.6/cdr' gcc -pipe -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -g3 -Iinclude -I../include -D_REENTRANT -D_GNU_SOURCE -O6 -march=i686

Hi! I have this errors compiling Asterisk 1.4.5 cdr_tds.c:86:2: warning: #warning "You have older TDS, you should upgrade!" cdr_tds.c: In function `tds_log': cdr_tds.c:213: error: too many arguments to function `tds_process_simple_query' cdr_tds.c: In function `mssql_connect': cdr_tds.c:326: error: `TDSCONNECTINFO' undeclared (first use in this function) cdr_tds.c:326:

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

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

Sorry for the numerous posts, I found that an old (~ June) post had the same title and confused me (and the list server) greatly (and made it hard to get this as a new thread). Anyway... I'm trying to get the RODBC package to work with a MS Sql database (Wonderware's InSQL). I'm able to connect to the database using the following: version _

I am getting segfaults when I try to read a large binary object from a SQL Server database via RODBC. I am using the FreeTDS ODBC driver, and it has been working fine when reading from this same database. I have included relevant parts of the session below. Each row of the v_MAFiles view holds a text, html or pdf version of a document. The FileType entry is one of TXT, PDF, or HTML. If

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

I am using sqlSave to save my data into an existing table at MS SQL Server database. Previously my code ran smoothly but all of a sudden it stopped working. Here is my code: sqlSave(con, highVol, "dbo.futuresHighVol", append=TRUE, rownames=FALSE) Error: sqlSave(con, highVol, "jrgchis.dbo.futuresHighVol", append = TRUE, : 42S01 2714 [Microsoft][ODBC SQL Server Driver][SQL

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

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 want to use the cdr to record the call log to my Microsoft SQL Server using unixodbc and freetds.... but when I compile, I've got this message.... Does anyone have the same problem and/or know how to solve it ? Thanks Baste regards David Masure make[1]: Entering directory `/usr/src/asterisk/bristuff-0.2.0-RC7k/asterisk-1.0.6/cdr' gcc -pipe -Wall -Wstrict-prototypes

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.)

Buenas tardes, Estoy tratando de realizar un update en SQL desde R: sqlUpdate(conexion1, data.frame(AUXILIAR), tablename = "AUXILIAR") y me devuelve el siguiente error: *Error in sqlUpdate(conexion1, data.frame(AUXILIAR), tablename = "AUXILIAR", : * * data frame column(s) Corteoptimo Cortediario not in database table* El problema es que sí existen esas columnas en SQL pero

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

Greetings guRus -- I have successfully queried a large (24,445 rows by 281 cols.) in-house database using the following RODBC query (without the line breaks) testout <- sqlQuery(channel, "select idSchedule,EXCL_Total from dbo.vwC1198_2006_RawData_With_CMPL_EXCL") This returns a dataframe of 24445 rows and two columns (as intended), but the following command testout

Hi, I'm having a bit of a problem with storing voicemail messages in an odbc database. I *think* I've got everything configured correctly but messages are stored on the asterisk server instread of in the database. System info 64 bit redhat RHEL 5.1 Asterisk 1.4.26 unixODBC installed used makemenuselect to instal res_odbc and cdr_odbc Back end database DB2 Database name voiceml

I got a table on SQL Server, which has columns EquationId (int) and Formula (varch(900)). I need to select Formula with certain EquationId, for example, Select Formula from OGA_DEV.dbo.Equation where EquationId = 3 I tried to work within RGui using RODBC: > library(RODBC) > conn = odbcConnect("SQL Server") > odbcQuery(conn, "Select Formula from OGA_DEV.dbo.Equation where

I wish to query tables that are NOT in the default SQL Server 2012 database. At work I am using SQL Server 2012 and Windows 7. I tested the following on my home set up of Server 2012 and Windows 7. I am using RStudio. I wish to connect to several SQL Server 2012 databases from R. This page helped me get started. http://andersspur.wordpress.com/2013/11/26/connect-r-to-sql-server-2012-and-14/