search for: testdb

Hi Everyone, I'm so confused. I've been trying to save data to a table but I keep getting an error that says the table does not exist and at other times saying that it does. So here are some statements: > sqlQuery(channel, "select top 1 * from > TestDB.[SILICON\\holouis1].clep_tier_shift") State NB Change_Number 1 IL 2005-02-08 7 It exists and I can get data from it, but if I try to use fetch or columns: > sqlFetch(channel, "TestDB.[SILICON\\holouis1].clep_tier_shift") Error in odbcTableExists(channel,...

...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 this code: testdb <- file.path("c:/Salmon_data.mdb") channel <- odbcConnectAccess(testdb) Data <- sqlFetch(channel,"Table1") When I replace it with an Access 2007 file: testdb <- file.path("c:/Salmon_data.accdb") channel <- odbcConnectAccess(testdb) Data <- sqlFetch(...

...ry 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 2002 My .my.conf contains this: [client] user = zak host = localhost password=<something> [rs-dbi] database = sdata [testdb] host = localhost database = testDB and connecting through the mysql client is no problem using those se...

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 execute "rake db:migrate" so that 3 tables corresponding to 3 models will get created in database "testdb" & schema_info table will have version =...

Hi I just want to study the core of btree function. So I hava a small test program. I try to add different items 1000000 times. (test1 , test1) (test2 , test2) (test3 , test3) .....(test1000000 , test1000000) after that I run the program again and again step 1 , db file size is 54099968 , get_entry_count is 1000000 step 2 , db file size is 108208128 , get_entry_count is 1000255 step 3 , db

...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 ####### library(sqldf) sqldf("attach testdb as new") In.File <- "C:/JP/Temp/2008.csv" read.csv.sql(In.File, sql = "create table table1 as select * from file", dbname = "testdb") It errored out with message NULL Warning message: closing unused connection 3 (C:/JP/Temp/2008.csv) When this failed,...

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...

...1G RAM and with the code below it even fills the whole 1G of swap. I just don't understand how 12e6 * 3 can fill such a huge range of RAM? Thanks for clarification and potential solutions. ## my code library(RMySQL) drv <- dbDriver("MySQL") ch <- dbConnect(drv,dbname="testdb", user="root",password="mysql") testdb <- dbGetQuery(ch, "select id, group, measurement from mydata") dbDisconnect(ch) dbUnloadDriver(drv) ## end of my code Cheers Christoph

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 run basic stats or manipulate the data I've imported, I can onl...

When I install the 2.7.3 "mysql" gem on Windows XP (trying to prepare for the requirement to use the mysql gem in Rails 2.2.2) by using: gem install mysql I get a mysql-2.7.3-x86-mswin32 directory under gems, but underneath that, only a docs directory, an ext directory, and README, Rakefile and .require_paths. I then cannot do any connecting to my MySQL databases. Shouldn''t

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,

...ent 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 obvious reasons. pages, components, and books are all tables in the same db. require ''active_record'' module TestDB class Inherited < ActiveRecord::Base self.logger self.default_timezone :utc self.establish_connection(params) end class Page < Inherited puts self.name puts self.table_name end class Book < ActiveRecord::Base puts self.name puts self.table_name end e...

...en 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 linked to that database. When I'm in R I tried to coneect to it using the command odbcConnect("testdb") but it doesn't work. I received these messages: Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: ODBC connection failed in: odbcDriverConnect(paste("DSN=", dsn, &quo...

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: no such file to load -- pg Any idea about where this comes from ? Thanks for help ! Fred -- Posted via http://www.ruby-forum.com/. -- You received this message beca...

...C=MYDOMAIN,DC=NET.ldb > > How does this file relate to the sam.db file? Is it safe to edit this > file directly to remove the offending GUID? Looks like I have been barking up the wrong tree on this. I copied the ldb mentioned above to a backup and manually removed the entries that the testdb was complaining about. Testdb now comes back clean, but the Invalid security ID structure error continues. The logs are showing multiple instances of: Unable to convert SID (S-1-5-11) at index 5 in user token to a GID. Conversion was returned as type 0, full token: I have a 74k log file that re...

...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 fashion (in python): import xapian db = xapian.WritableDatabase("testdb") doc = xapian.Document() tg = xapian.TermGenerator() tg.set_document(doc) tg.index_text("I am walking, always walking.") db.add_document(doc) Then you can run NEAR queries: import xapian db = xapian.Database("testdb") qp = xapian.QueryParser() qp.set_database(db) def qu...

...>> How does this file relate to the sam.db file? Is it safe to edit this >> file directly to remove the offending GUID? > > Looks like I have been barking up the wrong tree on this. I copied the > ldb mentioned above to a backup and manually removed the entries that > the testdb was complaining about. Testdb now comes back clean, but the > Invalid security ID structure error continues. The logs are showing > multiple instances of: > Unable to convert SID (S-1-5-11) at index 5 in user token to a GID. > Conversion was returned as type 0, full token: > >...

...cess 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) > channel <- odbcConnectAccess("C:\\temp\\testdb.mdb") > x <- sqlFetch(channel, "testtable", as.is = TRUE) # need as.is so that X won't be converted to numeric > summary(x) X Y Z Length:1 Min. :42 Length:1 Class :character 1st Qu.:42 Class :character Mode :charact...

...setting or the classpath setting, but I''m using Open Client, so should there be any need for the JDBC settings? Ok, things looked promising, and I started creating a test rails app. rails testapp I then edited the database.yml to fit Sybase ASE development: adapter: sybase database: testdb username: username password: password host: sauron The host, sauron, is defined in the sql.ini file. Running rake db:create tells me that the database testdb already exists. (true) ruby script\generate scaffold person first_name:string last_name:string WORKS OK rake db:migrate --trace FA...

...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", "test123") # get server version string and display it row = dbh.select_one("SELECT VERSION()") puts "Server version: " + row[0] rescue DBI::DatabaseError => e puts "An error occurred" puts "Error code: #{e.err}&q...