similar to: DB2 and SQL Server Drivers

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

I have followed the cookbook on http://wiki.rubyonrails.org/database-support/ms-sql but am having problems with the rails part. I can connect to the database using sqsh so I think all the freetds plumbing is good. When I try to connect to the db with a rake db:migrate or just using script/ console I get this error: >> Client.find(:first) DBI::InterfaceError: Unable to load driver

Dear R-fans, My database access package RODBC is now available on CRAN. For those who have never used it, odbc is a database and platform independant API which provides an SQL interface to a large number of database engines. The databases supported include not only SQL based RDBMS but also CSV files, foxbase, dBase, MSExcel etc. ODBC has been promoted mainly by Microsoft and this is where the

Dear R-fans, My database access package RODBC is now available on CRAN. For those who have never used it, odbc is a database and platform independant API which provides an SQL interface to a large number of database engines. The databases supported include not only SQL based RDBMS but also CSV files, foxbase, dBase, MSExcel etc. ODBC has been promoted mainly by Microsoft and this is where the

How do i get (discover) all the table names within a database using ROR/ActiveRecord ? I wish to build a webapp that connects to a database on the fly, discovers tables and column names etc and then can show data or build a report based on user selection. The ActiveRecord API doesnt seem to give any method for getting table names. -- Posted via http://www.ruby-forum.com/.

This will give you something to run on when Oracle refuses to renew the MySQL InnoDB license next year..... Linux and Windows versions You can run DB2 Express-C on up to 2 dual-core CPU servers, with up to 4 GB of memory, any storage system setup and with no restrictions on database size or any other artificial restrictions. Business partners may choose to register for free redistribution of

On 3/30/2015 11:44 AM, John R Pierce wrote: > On 3/30/2015 8:32 AM, Harold Pritchett wrote: >> Db2 is running our of shared memory. > > open a ticket with IBM DB2 support. > > > IBM db2 Express-C does not include support. You get what you pay for (and db2 Express-C is free) Harold

Hi, i am trying to connect to a DB2 server using the DBI library. getData <- function() { driver <- dbDriver("DB2") conn <- dbConnect(driver,"server","uname","pword") data <- dbSendquery(conn, "select etc.") } When I run the function, i get the error > data <- getData() Error in

Hello, I have been trying to connect a Rails application to DB2 database. Based on information found on the web it doesn''t seem to be possible. Can some confirm the state of DB2 support with Rails? Thanks for you help, David _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

Hi evryone, I would like to access to DB2 on R on a linux machine (R and DB2 are on 2 pc linux ) I have read on the R-archive that RODBC work with DB2, but it is not clear for me, if it's only for R on a windows machine or if it's work also for R under linux ? My data base administrator say that it will not work with linux ? Is it true ? Is there another solution ? Thanks for your help.

Db2 is running our of shared memory. The environment: Virtual computers running under VMware ESXi hypervisor version 5.5. Two different virtual machines, each running CentOS 5, db2 express C, and Apache/PHP and vmware tools. The machines each have 8 GB of memory, 4 processors, and a couple of hundred GB of disk space available. Everything is running on the 64 bit versions. The actual

I am running R version 2.8.1 on Windows XP OS. This works fine. (Data.frame dta is created with records from the DB2 table.): sql <- "select * from storage.testappend_slt order by uut" dta <- sqlQuery(channel,sql) But when I try to append records (from data.frame newdta) to the same DB2 table. I get an error: sqlSave(channel, newdta, tablename = storage.testappend_slt, append

I am running R version 2.9.2 on Windows XP OS with RODBC version Version: 1.3-0. Has anyone out there in the R user community successfully appended records to a DB2 table on a remote database using the sqlSave function in the RODBC package? (or by any other means from R?) I posed a similar question a few months ago and unfortunately, did not receive a response. I was hoping recent upgrades to

I have developed a rails 3 app and for various reasons I have been compelled to try using DB2 as the underlying database system. Does anyone have much experience of using DB2 with rails 3? Any good pointers on resources? I have just been using postgres to date -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on

Anyone has a working installation of DB2 DBI driver for Ruby? Davide

I often forward IBM DeveloperWorks articles about RoR to this list. This is a new well-written ''Intermediate'' article using DB2 with Rails: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0705chun/ Hope this helps. Cheers Mohit. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups

Hello list, I've been having a tough time adding windows resource support to my ogg vorbise decoder, although I think I am close. Basically when I call ov_open_callbacks(), it doesn't ever return and repeatedly calls my seek_func. I'm hoping it is something obvious, but I can't see why my seek_func is being called endlessly. If the file is seekable, I should return 0, right? If

I am new user of wine. I have centos 2.6.18-128.el5 x86_64 GNU/Linux and wine-1.0.1. I installed jre for windows in wine and run .bat program that run a java SWT application taht access a database db2. After running for a few moments an error is generated, this error occurs only under wine. DB2 use port 50000. Application.commit Text : [ibm][db2][jcc][t4][2030][11211] A communication

Does anyone have any experience getting ODBC to work? I could really use some help here. I''m having trouble accessing a db2 database via odbc using rails. It''s an external database, that I import data from. I have placed the connection code in my model : unless connected? establish_connection( :adapter => "odbc", :dsn => "<dsn

Dear all, I have a different data sets and I am doing some calculations over time, For that every data set is split into junks based on the time stamps so one data set has like 10 timestamps. There is also the case that one data set has less than 10 timestamps. In my code I was doing the following lapply(Datasource,analysis_for_one_data_source)