similar to: RODBC and SQL Server

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

Howdy, I'm trying to use R to access Oracle 8i using the RODBC package On Linux Red Hat 7.3. Specs R version 1.51 Driver: Easysoft ODBC - Oracle driver Driver Manager: unixODBC I get the following error when trying to executing RODBC commands. Can anybody give me pointers as to what I'm missing or doing wrong > library(RODBC) > channel <- ("DSNName") >

I have a question for RODBC users out there. I have used the package with good results for some time. However, I have just switched from an OpenLink proprietary driver for MS SQL to the FreeTDS driver (I think it is MS SQL Server 2000 I'm connecting to if it matters). I was/am running them from unixODBC on a Linux Client. I think I have it set up fine since I can use "isql"

Hi I'm presently trying to connect to Oracle through RODBC / UnixODBC on linux (Red Hat 5). I've successfully connected through the easysoft drivers but the trial license has run out and I'm trying to connect via the default Oracle 11G driver. However I'm getting the following error > library(RODBC) > setwd (paste("/home/oracle/scripts/R")) > channel

Hi, Version info: R: 1.5.1 RODBC: 0.8.3 Oracle: 8.1.7 unixODBC: 2.2.2 Easysoft ODBC driver: 1.0.0.6 SunOS/Solaris: 5.7 I'm trying to get RODBC working with Oracle on Solaris. I've installed unixODBC and the Easysoft ODBC driver. There are no problems connecting to the DB and executing queries using unixODBC's isql interactive client. Using R and RODBC however, I can open a connection

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

I am trying to get access to a Microsoft SQL Server 2k installation on my network. To this point I''m not having any luck. I''ve followed the instructions at http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnOSX up to the point where you run the iodbctest where I get an error. The errors are: iODBC Demonstration program This program shows an

On Fri, Jul 30, 2010 at 1:15 PM, Fred Posner <fred at teamforrest.com> wrote: > On Jul 30, 2010, at 5:04 AM, Andra=C5=BE wrote: > > > Ok, problem is another, when I run configure, it write this: > > checking for tds_version in -ltds... no > > configure: *** > > configure: *** The FreeTDS installation on this system appears to be > broken. > >

Thanks again for everyone's help. I have a successful configuration. I used the "ODBC-combined" configuration which is documented here: http://freetds.org/userguide/odbcombo.htm here are the config files residing in my home dir: -bash-2.05b$ cat .freetds.conf [global] tds version = 7.0 [QAI] host = Mqa3.xxx.yyy.com port = 1433 -bash-2.05b$ -bash-2.05b$

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

Help! I've been using mysql for cdr storage, I need to switch to MS SQL. I must be stupid or something but I cannot figure out how to setup the cdr_tds. I have FreeTDS configured properly, but my unixodbc is not working properly either... I'd be happy with either solution, but I'm in need of assistance. Luke Catranis

Anyone out there using Linux RODBC and unixODBC to connect to a Microsoft SQL server? If possible can someone post a sample .odbc.ini file? I saw a few discussions on the archives a few years ago, but no config file details were available. Thanks, Whit This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended

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

Hello everyone! I'm having the dreaded repeated rows problem in RODBC. Specifically, when I have a NULL value in a column, odbcFetchRows reads the value not as NULL or NA but as the most recent non-NULL value in the column. If there is no such non-NULL column, odbcFetchRows reads the value as 0. Let me give you an example (though you won't be able to run it with the "product"

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

Hi, i want to load the cdr into oracle using unixODBC. I'm using RH 9 2.4.20-30.9smp, unixODBC 2.2.6, easysoft odbc driver for oracle 1.3.1. My unixODBC is working well. With isql i can connect to the database, do selects, inserts and so on. I created the table cdr as described on the asterisk wiki site. When i configure the cdr_odbc.conf with the needed values, then * does not start any

Hi I have problems trying to load asterisk call data into the cdr table using cdr_odbc config. My unixODBC is properly configured and it's working fine (able to connect, load data, query tables, etc.). unixodbc is configured to use easysoft Oracle ODBC library. Table cdr was created following instructions in asterisk wiki site. My /etc/asterisk/cdr_odbc.conf is configured as follow:

I try to use BusinessLine98 on my Linux. The database is store on a Win2000 server with SQL server. So I install unixODBC but now I need a ODBC-ODBC bridge to connect my Linux to Win2k/SQLserver!?? EasySoft solution is not free. Is there any free solution?? Perhaps there is another solution without the use of UnixOdbc? Perhaps I can use odbc driver from my windows install via Wine?? Have got