search for: dbi

...onfig.status: creating src/Makevars ** libs gcc -m32 -std=gnu99 -I/usr/include/R -I/usr/include/mysql -I/usr/local/include -fpic -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -c RS-DBI.c -o RS-DBI.o In file included from RS-DBI.h:32, from RS-DBI.c:22: S4R.h:40:17: error: S.h: No such file or directory S4R.h:53:24: error: Rversion.h: No such file or directory S4R.h:54:51: error: missing binary operator before token "(" S4R.h:62:26: error: Rdefines.h: No...

...libs gcc -m64 -std=gnu99 -I/usr/include/R -DRSQLITE_USE_BUNDLED_SQLITE -DSQLITE_MAX_SQL_LENGTH=2000000 -DSQLITE_ENABLE_RTREE=1 -DTHREADSAFE=0 -I/usr/local/include -fpic -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -c RS-DBI.c -o RS-DBI.o In file included from RS-DBI.h:32, from RS-DBI.c:19: Rhelpers.h:16:24: error: Rversion.h: No such file or directory In file included from /usr/include/R/Rdefines.h:26, from Rhelpers.h:18, from RS-DBI.h:32, from...

...nrails.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 ''ODBC'' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb:286:in `load_driver'' from /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb:236:in `load_driver''...

Hi all, I would like the following code to work, but it doesn't: library(DBI) library(RODBC) m <- dbDriver("RODBC") # Example for dbConnect(DBI), causes error m <- dbDriver("ODBC") # Example for DBIDriver-class(DBI), causes error The errors are: Error in do.call(as.character(drvName), list(...)) : could not find function "RODBC" (subs...

Hi, I'm trying to use R's DBI interface but it appears to be broken. I am using R 1.8.0 on Linux, and have just installed DBI 0.1-6 through the command 'install.packages("DBI")'. Installation went fine, but now when I try to do a simple dbConnect(), it won't do anything besides complaining about an inter...

require ''dbi'' # 0.4.2 dbh = DBI.connect(''DBI:ODBC:PACS'', ''username'', ''password'') This works in IRB; in Rails it fails (taken from Rails console): DBI::InterfaceError: Unable to load driver ''ODBC'' (underlying error: uninitialized c...

Hello guys, I was told by the client to install Perl DBI version 1.52 on a el6 box, by default el6 branch comes with DBI version 1.6x, this version is AFAIK not the desired one. First I tried installing DBI 1.52 from some rpm package [1], which had some dependencies, Perl 5.8.8 and dbd.4.4.x, this last package was also present el6, so it made conflict a...

...the error message is as below. The same will work if I do U2date install Package name. But yum wouldn't do.! This problem exists with every install or update I do with Yum. Can some one direct me where am I going wrong? Thanks Rajeev [root at Projects03 Download]# yum install perl-DBI-1.40-8.x86_64 Setting up Install Process Setting up repositories update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 ext...

...ally got ROracle up and running on windows? >> unable to find an inherited method for function "dbConnect", for signature "OraDriver" I can happily connect to the same database through RODBC. Oracle client, version 9.2 installed, amongst others. Sean > library(DBI) > library(ROracle) > > packageDescription("ROracle") Package: ROracle Version: 0.5-7 Date: 2006-02-13 Title: Oracle database interface for R Author: David A. James <dj at bell-labs.com> Jake Luciani <jakeluciani at yahoo.com> Maintainer: David A. James <dj at bel...

...his file is autogenerated. Instead of editing this file, please use the # migrations feature of ActiveRecord to incrementally modify your database, and # then regenerate this schema definition. ActiveRecord::Schema.define() do # Could not dump table "SalesCustomers" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "SalesPlans" because of following DBI::DatabaseError # EOF OLE error co...

Has anybody gotten Apache-DBI to work under CentOS4? My installed rpms are: httpd-2.0.52-12.1.ent.centos4 (came with CentOS4) mod_perl-1.99_16-4.centos4 (came with CentOS4) perl-Apache-DBI-0.94-1.2.el4.rf (from Dag's site) --this includes Apache::DBI and Apache::AuthDBI In my '/etc/...

Dear All, I am having a bit of problem using the DBI and RMySQL package. I have already installed DBI but now I want to connect to MySQL. So how do I do it. The CRAN package repository does not have RMySQL windows binary to install from? Regards, Indrajit Sen Gupta Business Analyst Mu Sigma Business Solutions Pvt Ltd #21/1-1, Nawab Towers Cunningh...

Full_Name: Fernando Henrique Ferraz Pereira da Rosa Version: 1.8.0 OS: Linux 2.4.21 Submission from: (NULL) (200.206.211.169) After installing R 1.8.0, the R DBI interface stopped working. I tracked it down as a problem in the 'methods' package, that comes in the default installation. Somehow the function '.valueClassTest' which is defined on package 'methods', is not being defined. To ilustrate how this breaks DBI, try thi...

...me network - with no connection issues from any other clients. This machine isn't currently doing anything else except for running this script. Output from running it several times looks like this: R at ss-dev:~/scripts$ ./dbCheck.R Loading required package: methods Loading required package: DBI Loading required package: rJava NULL R at ss-dev:~/scripts$ ./dbCheck.R Loading required package: methods Loading required package: DBI Loading required package: rJava NULL R at ss-dev:~/scripts$ ./dbCheck.R Loading required package: methods Loading required package: DBI Loading required package: r...

There is something seriously wrong with DBI support for SQL server. I have tried both DBI::ODBC and DBI:ADO and the following code always fails. ---------- Code require ''dbi'' host= "DEVELOPMENT_DATABASE_SERVER" database="adventureworks2000" username="someusername" password="Somepwd"...

...ng the library function, it appears that lib.loc is not being used and instead the central repository is being used. We've even tried modifying .libPaths( ) so that our local path is first in the search list. Is this a bug or a "feature"? For example: > install.packages('DBI',lib='/data1/bsi/epi/s105816.SNPlinkage/CNV/rlib') > library(DBI, lib.loc='/data1/bsi/epi/s105816.SNPlinkage/CNV/rlib') I can look in my directory and see that DBI is version 0.2-5, but when I use the library command I get the version installed in the central location inst...

Hello everyone! Congratulations by this gorgeous software. My name is Germán Carrillo, I'm writting from Colombia. I don't have much experience with R, reason why I use the R-GUI (version 2.5.1) on Windows. I have some problems with DBI package, I want to connect to PostgreSQL database but I don't know the way to do it. I was reading the DBI manual and I tried write in my R Console the next command: pg <- dbDriver("PostgreSQL") But R says: Error en do.call(as.character(drvName), list(...)) : no...

Hi. I frequently use RMySQL package to interface R with MySQL databases. I was having a try with package DBI and I got the following error: > library(RMySQL) > library(DBI) > drv <- dbDriver("MySQL") > ch <- dbConnect(drv, dbname="mydb", user="myuser", password="mypasswd") > ibm <- dbGetQuery(ch,"select * from table where field1='va...

...gram Files\R\rw1090\library\ROracle\src>nmake Microsoft (R) Program Maintenance Utility Version 6.00.9782.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cl /I"C:\\Program Files\\R\\rw1090"\\src\\include /MT /Ox /D "MSVC" /D " WIN32" /c RS-DBI.c Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 12.00.8804 for 80x86 Copyright (C) Microsoft Corp 1984-1998. All rights reserved. RS-DBI.c cl /I"C:\\Program Files\\R\\rw1090"\\src\\include /MT /Ox /D "MSVC" /D " WIN32" /c RS-Oracle.c Microsoft (R) 32-...

...ng? If I only want to read tables from the database and work on them in R, is there an easier package? > Sys.getenv("MYSQL_HOME") [1] "C:\\Program Files\\MySQL\\MySQL Server 5.5" > install.packages('RMySQL',type='source') also installing the dependency ?DBI? trying URL 'http://probability.ca/cran/src/contrib/DBI_0.2-5.tar.gz' Content type 'application/x-gzip' length 308395 bytes (301 Kb) opened URL downloaded 301 Kb trying URL 'http://probability.ca/cran/src/contrib/RMySQL_0.9-3.tar.gz' Content type 'application/x-gzip...