similar to: sqlSave help!

Hi all, I'm trying to import Microsoft Access data into R. It looks like I'm supposed to use the ROBC package, and this works fine with old Access files (those with an .mdb extension). However, lovely Microsoft must constantly update their software. Modern Access files have an .ACCDB extension. I cannot seem to coerce R to import data from such a file. Any advice? I've been using

Hi all, I am facing a problem while using rails "migrate" feature for creating tables in a database. Following are the details. I have 2 applications say "app1" & "app2". I want both of them to use same database say "testdb". For "app1", I create 3 models which in turn create 3 migration files with prefix, 001_, 002_ & 003_. Now I

SQldf with sqlite and H2 I have a large csv file (about 2GB) and wanted to import the file into R and do some filtering and analysis. Came across sqldf ( a great idea and product) and was trying to play around to see what would be the best method of doing this. csv file is comma delimited with some columns having comma inside the quoation like this "John, Doe". I tried this first

Hi all, This is a potentially very stupid question about MySQL <-> R interaction, but I have not been able to solve it. I'm just trying to connect R to my MySQL databse, and gets this: > library(RMySQL) Loading required package: methods > m <- dbDriver("MySQL") > con <- dbConnect(m,group="testdb") Process R segmentation fault at Wed Oct 16 07:04:30

Hi, I want to import some data from Access and I am using the following codes: testdb <- file.path("c/../db1") channel <- odbcConnect("testdb") sqlFetch(channel,"tbl",colnames = TRUE, rownames = FALSE) It comes out the error message: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default

Hi I just started with RMySQL. I have a database with roughly 12 millions rows/records and 8 columns/fields. From all 12 millions of records I want to import 3 fields only. The fields are specified as:id int(11), group char(15), measurement float(4,2). Why does this take > 1G RAM? I run R on suse linux, with 1G RAM and with the code below it even fills the whole 1G of swap. I just

Hi all, I am very new to R and I'm trying to import data from Microsoft Access. So far, I've managed to do so successfully using the following code: testdb <- file.path("c:\Databse.accdb") channel2 <- odbcConnectAccess2007(testdb) data.table <- sqlFetch(channel2,"data") This successfully imports a table(?) called "data.table". But when I try to

First of all, sorry for the crossposting, but I put this into the Ruby Forum first of all, but was pointed to this as a more appropriate location. I''m using ActiveRecord and ActiveSupport in a non-rails environment to connect to multiple databases, and I''ve found the following (single database) to cause me an error. Note that params is my database settings and omitted for

On 10/7/16 8:51 AM, Ron García-Vidal via samba wrote: > On 10/6/16 1:54 PM, Ron García-Vidal via samba wrote: >> On 10/6/16 12:50 PM, lingpanda101--- via samba wrote: >>> On 10/6/2016 12:35 PM, Ron García-Vidal via samba wrote: >>>> On 10/5/16 11:37 AM, Ron García-Vidal via samba wrote: >>>>> On 10/5/16 11:17 AM, Rowland Penny via samba wrote:

Please keep replies on the mailing list — more people can help (and benefit) that way :) So OP_NEAR looks for its terms close to each other (hence "near"). The window is how far away they can be. Probably the easiest way to play with this is using the NEAR syntax in the query parser. So if you had a plain text document: I am walking, always walking. And index it in a very simple

On 10/7/16 9:25 AM, Ron García-Vidal via samba wrote: > On 10/7/16 8:51 AM, Ron García-Vidal via samba wrote: >> On 10/6/16 1:54 PM, Ron García-Vidal via samba wrote: >>> On 10/6/16 12:50 PM, lingpanda101--- via samba wrote: >>>> On 10/6/2016 12:35 PM, Ron García-Vidal via samba wrote: >>>>> On 10/5/16 11:37 AM, Ron García-Vidal via samba wrote:

Hi guys, Having issues with doing an insert statement using ast 1.4.24: [START] dsn=mssql-asterisk write=INSERT INTO testdb (callarrival,callerid) VALUES ('${VAL1}','${VAL2}') SET(ODBC_START()${TIMESTAMP},${CALLERID(num)}) No errors pop up on execute, but nothing gets inserted. Read and update work fine, Wondering where I'm going off track with this, Thanks,

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 R-users, I am working with R version 2.10.1 and package RODBC Version: 1.3-2 under windows. Say I have a table "testtable" (in an Access data base) with 3 columns and 1 row that looks like this: X Y Z 0012345 42 42,1 The columns are of these types: X - character, Y - Long Integer, Z - Decimal. I use RODBC to get these data into R: > library(RODBC) >

Hi I''m trying to use the activerecord-sybase-adapter to be able to use ASE with my rails applications. But, I am struggling... I followed (most of) the steps on this informative page: http://trevoke.net/blog/2009/09/11/connecting-to-sybase-with-rails-on-windows-xp/ Initially I had Rails 2.3.5 installed. I copied the "Ruby Sybase files" as instructed and the Sybase dll files

Hi all, I installed Rails 3.0 + PostgreSQL 8.4. Installed the gem postgre-pr I added " gem ''postgres-pr'' " to my Gemfile I defined my database.yml with: # PostgreSQL 8.4 development: adapter: postgresql encoding: unicode database: testdb pool: 5 username: test password: ****** I run rails server which starts, but application environment returns this error:

Hi. I am connecting from Console to SQL Server with ruby on rails on windows XP but while executing the following code, only the coloured code is executing, i want the exact procedure, how to connect from database step by step procedure.. require "dbi" begin # connect to the SQL server dbh = DBI.connect("DBI:ODBC:TESTDB:localhost", "testuser",

On Thu, Mar 12, 2015 at 8:57 AM Tim Dunphy <bluethundr at gmail.com> wrote: > Hey everybody, > > I'm trying to get mysql master/slave replication to work under SSL. I've > created the certs for both the slave and the master. I've configured the > master and slave my.cnf. And it does appear that replication is actually > working. > > Master is actually

Hi, Maybe this is off-topic, but I am having trouble using Rails with an older version of MySQL. When I try to run the db:migrate task, I am getting the error: rake aborted! Access denied for user: ''@localhost'' to database ''testdb'' In my database.yml file I have mentioned a username, but activerecord does not seem to recognise it :( Environment: MySQL:

I noticed that some of the ActiveRecord adapters depend on ruby-dbi. I''ve just started to play with the ruby-dbi database driver DBD::Proxy, which allows me to connect to other ruby-dbi drivers running on other operating systems. What seems more practical, developing a ActiveRecord database adapter for DBD::Proxy, or would you just target a specific database, and just depend on