similar to: Connectivity Code

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

I wrote a rexml script that parses rather big xml files (DOM parsing) and builds an object out of them. This is what it looks like after i parse the xml file and display the object: [#<Article:0xb79e7428 @brand="This is a story from ", @id=5337, @fblurb="burb", @ntype="news type here", @copy="Copyright \302\251 2006 ", @source="source",

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

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

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

Regards, Seeni Rafiyullah Khan A, * * -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more

This is for Rails 3.1.1 I have a field called last_seen in a model. This field will be updated when the something about the record is seen in the real world (don''t worry about this part) So I go x.update_attribute(:last_seen, Time.now) and the following happens is UPDATE "blah" SET "last_seen" = ''2012-10-23 08:57:46.179288'', "updated_at"

Dear All, I seem to have stumbled across an AGI problem; I have written an AGI Script (bottom of this email); The script does the following; Makes a CDR entry when called Records the call Updates the CDR Finds a corresponding DNIS from the SMDR table (captured via a serial port logger) Matches up the record and updates the CDR. The script works perfectly in my test lab and has been doing so

I've been trying to get a basic 5 question IVR survey working in an AGI script, and am having trouble with the SQL portion not updating the table. When I take out all the AGI references, and run just the perl script, the table updates with no problem(DBname,username,password have been substituted in this example for the actual values): #!/usr/bin/perl # # use DBI; $DATETIME =

Here''s the script. I would have posted it to a website, but I figure this''ll be better so it is always on the list for people in the future in case they wanted to see it. If you have any questions about any of it, please let me know. Mike and I aren''t the cleanest of programmers. Cron the script to run whenever you need it to. :) #!/usr/bin/perl # # TC Helper Script:

Hey all, I'm sorry to bother you with something so trivial, but I seem to be having an issue with the Asterisk::AGI module. I am a relative newbie with Perl so it could be a stupid syntax mistake that I missed. It seems when I try to execute either the stream_file or the get_data subs nothing is actually done. It doesn't seem to stream the files, but on the console it says it played the

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

I'm in search of useful ACD type statistics from the queues. Ie talk time, ratio's, dropped calls etc. The flat file queue_log is nice, but more useful would be the data in Postgres or Mysql. Unfortunately the queue module does not yet support ODBC DB logging (yet). In the meantime this quick and dirty hack gets the job done. Replace the flat file with a unix named pipe.

Here''s some happy-fun Perl to make your storeconfig/virtual resources day better. I probably should have written this in Ruby, but perl comes naturally :) #!/usr/bin/perl # # Perl DBI to remove all related entries from Puppet''s storeconfigs database. # Use when a host is removed from the Puppet network forcibly # Alternatives: run puppet on host to be removed with a blank

thanks Billy. I replaced print "STREAM FILE $filename \"\"\n"; with print "EXEC PLAYBACK $filename \n"; and it worked fine. Interestingly when I did print "STREAM FILE beep \"\"\n"; within the script, it worked. If I wasnt a newbie to asterisk I wouldve thought this to be strange. >From: "William Piper"

I'm having trouble getting an AGI exec command to spawn app_disa. The script executes properly, but does not spawn DISA. The CLI gives no helpful clues. Am I doing the exec incorrectly? I want to have a way to authenticate callers to the extension by Caller ID... if their caller ID is in my database and set to active, they can call out. [like a calling card but auth'd by CID instead

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, I''ve been playing around with using DBI instead of ActiveRecord ''cause I just love to beat myself up! ;) Is this an okay way to do this, or is there any other more creative ways? require ''dbi'' module MyApp:Models class DB def self.dbh DBI.connect(''DBI:Mysql:dbname'', ''username'',

Hi, dear guys! I have following super simple program dbh=DBI.connect("DBI:SQLite3:barron.db") sth=dbh.prepare("INSERT INTO WORDS VALUES(?,?,?)") 3.times{ sth.execute("1","2","3") } and it gives me error : /Users/tsdeng/.rvm/gems/ruby-1.8.7-p302/gems/sqlite3-ruby-1.3.1/lib/sqlite3/statement.rb:41:in `bind_param'': library routine called