similar to: ODBC Connectivity

I'm not sure if this problem is repeatable or particular to my machine. The following works fine - > odbcConnect("demoteam", uid = "demo", pwd = "demo") This causes R to crash - > oracle.info <- list(channel = "demoteam", uid = "demo", pwd = "demo") > demo.db.connect <- function(ora.info = oracle.info) { + channel

Thanks in advance for any help I can get on this. I'm trying to change variable names between 2 systems - R and old SPSS, Oracle. I'm using the grep() and gsub() commands but I'm getting the following result - > test.dat <- c("a", "b.c", "d.e.f", "p_q,r") > test.dat [1] "a" "b.c" "d.e.f"

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" (substitute

Hello R Helpers, Before setting up a connection with RODBC, I would like to present my users with a pick list of ODBC data sources available in their environment. I may be missing something, but don't see anything in RODBC itself to return list of sources for use in select.list(). Any hints? I'm running 2.3.0 on Win XP SP2. -- TIA, Jim Porzak Loyalty Matrix Inc. San Francisco, CA

I have been using RODBC for a while with no complaints (R 2.0.1 patched under WinXP), then I saw a link (http://grass.itc.it/statsgrass/r_and_dbms.html) showing that Rdbi claims to run a query in 5 seconds that takes RODBC 4.3 minutes. That was hard enough for me to believe that I wanted to try some tests myself, but I cannot get Rdbi to connect to my ODBC database. Here is what works for RODBC

Help! I have a very large data file with about 100 columns. Instead of loading all of the columns using read.table() (my PC won't be able to handle the resulting data frame), I'd like to read in one column of the datafile at a time using scan() in conjunction with the 'what = ' option. I've tried loading just the third column using - > scan(file.name, what = list(NULL,

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

R-sig-Debian help, I have installed an ODBC Driver for Linux. I want to connect to our database through R via: >library(RODBC) >con <- odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") Warning message: In odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") : ODBC connection failed I don't really know whether this

I'm looking for an optimal approach to access Oracle databases via RWeb applications. I'm new to R but familiar with programming functions and web pages for the S+ Statserver. I'm now going through the motions of migrating S+/Statserver applications to R/RWeb as a feasability exercise. I can access databases using ODBC directly in R or S, and using Statserver, but I have not succeeded

Hello everybody, I have tried to connect to external databases (specifically, to a MS Access database in my computer) from R using the RODBC package. Unfortunatelly I haven't been able to do it, even if I 'followed' the instructions in the manual. COuld someone please help me? I have a MS Access database in my computer and I went to the control panel in order to create a DSN file

Dear all, Retrieving an Oracle "Date" data type by means of RODBC (version 1.2-4) I get different classes in R depending on which operating system I am in: On MacOSX I get "Date" class On Windows I get " "POSIXt" "POSIXct" class The problem is material, as converting the "POSIXt" "POSIXct" object with as.Date() returns one

Hi R users and Dr. Uwe Ligges: I read on the ROracle pre-compiled binary README file that: "Although the package ROracle passes make check, it seems to be dangerous to distribute it: I do not have the software available this package depends on." Why it is dangerous to use ROracle for windows? What software does ROracle depends on in windows platform? Is there a GNU solution for an

Hi R users: I am using RODBC to create some new ".xls" files each with several sheets (about 100) with sqlSave() from a data.frame inside R without any problem, but on windows XP platform. I would like to know if it is posible to make a similar solution on linux with openoffice? RODBC work only (for the moment) with ".xls" on windows, via the ODBC driver. Is it posible to

Hi all, I'm having trouble connecting to an oracle database using RODBC under winXP. Unfortunately I can't really send a reproducable error as the initial call to odbcConnect seems to hangs R and I have to kill the session. I have been using RODBC to sucessfully connect to an MS Access DB that has tables linked through to the oracle database in question and that seems to work OK but it

All, I'm trying to connect to a remote SAS server using SAS's 9.1 ODBC driver and the RODBC package. I'm running R-2.6.1 on Win XP. I can successfully connect to the database, but no matter which table I query, I get back an empty table with only the column headers. For example: > sqlQuery(con, "select * from PRICES.DB_PRICES") [1] COMMOD_CURVE START_DATE

[sorry, but this is a re-post - I forgot to set the subject line the first time around] Hello, I would like to access an Oracle database running on Solaris from R on my linux desktop. I have had a look at the R Data Import/Export manual, and downloaded RODBC and unixODBC, but I am still quite confused about how to proceed. It appears to me that I still need to get an Oracle ODBC driver, and

Hi all, anybody get connection with Filemarker 10 for mac? How do that? I suppose did right, but it is not working. -- Daniel Marcelino Phone: (647) 8910939 [[alternative HTML version deleted]]

I have just finished a first rough cut of RODBC, a database connectivity addon. In theory it should allow access to any odbc compliant database for which the driver set is installed. On unix this includes MySQL, mSQL and postgres using the unixODBC set. On windows it should include access, sqlserver etc if the odbc drivers are installed. For those who have never taken an interest in this,

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

Hi Friends, I am working on R-2.9.0 and i want to connect oracle through R, but i could not find ROracle (zip file for windows) on CRAN Packages. Can anyone suggest me how to connect Oracle from R in windows platform? I would be grateful if u can provide me code aswell. Thanks & Regards, Madan -- View this message in context: