similar to: Wine ODBC and unixODBC

All- Does anyone on the list have experience with building RODBC from source on a Linux box for use with DB2? I am using (all from source): R 2.0.1 unixODBC 2.2.9 RODBC 1.1-3 For example: [jcole]$ R CMD INSTALL RODBC_1.1-3.tar.gz 2> rodbc.log * Installing *source* package 'RODBC' ... checking for gcc... gcc checking for C compiler default output file name... a.out checking whether

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.

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

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

Trying to get a later version of the unixODBC RPM that is in Centos 5, I read in some posting that unixODBC.x86_64 2.2.12-1.el5s2 was in the testing repo but I was unable to locate it, currently it appears that we are runningunixODBC-2.2.11-7.1. I have looked in the Centos 5 Testing repo but do not see the 2.2.12 version....anyone have any pointers to move me along, thanks.

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

How does one get asterisk to timeout realtime request via res_odbc to unixODBC? I've set timeouts as appropriate for freetds (which unixODBC is using.) However, it doesn't seem to work. It takes over 3 minutes to timeout a connection and queries never seem to timeout, so a channel waiting on a query never terminates. I did notice that res_odbc.c never sets a timeout on the query

Hi, I'm trying to establish a connection to a MySQL database, and am using the rodbc package for it. This is in a GNU/Debian Linux box, with the corresponding Debian unstable packages. I can login to my MySQL databases from any shell and directory, so the problem is probably not there. Here's an example of what I'm doing: R> odbcConnect("test",

Hi, I noticed that if a column is named "end" in a data frame (table.df below), it leads to errors when trying to sqlSave()'it to a postgresql connection: ---<---------------cut here---------------start-------------->--- con <- odbcConnect("PostgreSQL-DB", uid="user", pwd="password", case="postgresql") R>

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)

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

Hello all. I am posting this on unixodbc-dev and pgsql-odbc as well as r-help to make sure all of my bases are covered (and because I'm not sure which one of these is the source of the issue.) Unixodbc with Postgresql seems to be working, but I am getting some errors that I don't understand and want to know why I am getting these errors before I put everything into production. I am

Hello, I am trying to set up cdr logging into MariaDB through ODBC. I have installed unixodbc unixodbc-dev and now I am struggling with configuring /etc/odbcinst.ini All the examples online use non-existent libraries, ie: [MySQL] Description = MySQL ODBC MyODBC Driver Driver = /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so FileUsage = 1 I have

Dear R Beginners, Experts and Users, I already asked this question on the R-sig-DB mailing list, but sadly didn't got a reply :-( . Keeping fingers crossed that I have more luck on the main R mailinglist :) . I'm trying to connect to a MySQl database via Gnu R using the RODBC interface. The conenction workes but I get an empty result string. Gnu R and the MySql DB are running on a 64 bit

Hello all, I try to setup weight watchers Points Plan. It runs fine exept it needs ODBC. I installed unixODBC on my Gentoo Box which got me one step further. Atm I have the Problem that the App Complains that it does not know what to do with the ODBC access it demands. Here the exact Error message of ODBC: [unixODBC][Driver Manager] Data Source Name not found, and no default driver

I know this is very off topic, but getting MySQL and unix ODBC to play nice via SSL on Centos has been a battle. I finally have it working via isql but when I connect via Oracle I get an error. If I use the mysql odbc connector directly: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC][MySQL][ODBC 3.51 Driver]SSL connection error

I recently installed mariadb-server 10.1 by adding the following repository: baseurl = http://yum.mariadb.org/10.1/centos7-amd64 ...all was well until we had a power failure and upon rebooting unixodbc was segfaulting. Once I did a yum undo, the mysql odbc driver was functional. I traced it to the following: [root at ec-ast yum.repos.d]# ldd /usr/lib64/libmyodbc5w.so | grep -iE

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:

i'm trying to run a windows-based application from my company in a Linux environment. it requires a mysql database to retrieve data. i am running PCLinuxOS MiniMe 2008. the issue i am having is that it does not seem that any WINE applications are able to connection to UnixODBC. i have installed mysql, configured it, installed UnixODBC, configured it (and verified connection to mysql