search for: mydb

I've been trying to get RODBC working in RAqua. For my database, let's call it "mydb", when I enter odbcConnect("mydb") or odbcConnect("mydb", uid="postgres", pwd="secret"), RAqua thinks for about 10 seconds, then crashes. mydb is a PostgreSQL 7.4.2 database running on my machine (Mac OS X 10.3.3). I am using the pgsqlodbc 7.2.5 driv...

...be delivered), so I turn for help to this list. I tried to use your FAME package written for R, but somehow I cannot get it working. I am using Windows XP and the newest R installation version 2.8.1. For example, if I run the following code I get the following error message: library(fame) mydb <- "O:/FameDB/national.db" mydb fameWhats(mydb,"TS21555100",getDoc = T) getfame("TS21555100",mydb) > library(fame) > mydb <- "O:/FameDB/national.db" > mydb [1] "O:/FameDB/national.db" > fameWhats(mydb,"TS21555100&qu...

...file with the first line being a header. For some reason I cannot seem to get it working. Combining examples 6 and 9 from the Google Code page (and R-help archives), I tried source("http://sqldf.googlecode.com/svn/trunk/R/sqldf.R") (do I need it for SQLite?) ## sqldf("attach 'mydb.db' as new") f <- file("myexample.txt") attr(f,"file.format") <- list(header=TRUE,sep="\t") sqldf("create table myexample as select * from f", stringsAsFactors=FALSE, dbname="mydb.db") ## or f <- file(fi) sqldf("cr...

Hi all: I have created a MS Access table named 'PredictedValues' through the statement below: myDB <- odbcConnectAccess("C:/Documents and Settings/Owner/Desktop/Rpond Farming.mdb",uid="admin",pwd="") sqlSave(myDB,PredictedValues,rownames=FALSE) close(myDB) But if I run the code again with new values I get the message below: Error in sqlSave(myDB, PredictedV...

...iverConnect (RODBC package) on Linux I am sure I'm doing something wrong here but not sure what. Our system administrator recently installed UnixODBC and the MyODBC driver on a Linux box running Linux version 2.6 x86_64. I have an .odbc.ini file in my home directory with following lines: [mydb] Description = MySQL server on my-server Driver=/usr/lib64/libmyodbc3.so SERVER=my-server I can successfully do the following: library(RODBC) channel <- odbcConnect("mydb") sqlQuery(channel, "show databases") And in general, I have no problems using odbcConnect to connect...

...e command line it runs successfully but in Puppet it fails. Can someone help me understand how the mysql is being executed with mysql? debug: Puppet::Type::Database::ProviderMysql: Executing ''/usr/bin/mysql -u admin -p''password'' -h vm-minux.comm.com -NBev create database mydb character set utf8'' err: /Stage[main]//Node[ssat-puppetagent-1.qcomm.com]/Test_mod::Db[mydb]/Database[mydb]/ensure: change from absent to present failed: Execution of ''/usr/bin/mysql -u admin -p''password'' -h vm-mlinux.qcomm.com -NBev create database mydb charact...

Hi - I am something of a newbie and am a little perplexed. When (trying to) modify a table I issue the following commands with subsequent errors sqldf("alter table Korea drop column code", dbname = "mydb") error in statement: near "drop": syntax error or sqldf("alter table Korea rename column hyr to hyrI", dbname = "mydb") error in statement: near "column": syntax error These are simple commands - am I missing something obvious? I can retrieve data f...

Hello, I want to know what is timeout for MS SQL connection? My config is: [mydb] enabled => yes dsn => MYDB pooling => yes limit => 200 share_connections => no username => login password => password pre-connect => yes backslash_is_escape => no In the peak , I can see : ODBC DSN Settings ----------------- Name: mydb DSN: MYDB Pooled: Yes...

...and transfer start again I heard about the --partial option in order to keep the partial transferred file. I thought that rsync will apply his incremental check and update alghoritm on that partial file and resume the transfer. Unfortunatelly , the temporary file name is a unique file name ( .mydb-dump.sql.bz2.MkVSHy ) and in the next transfer session it will be another one , so "partial" transfer files does not help me much. Can "--compare-dir" help me? I need a good , reliable , transfer of a binary file that can be resumed in the next transfer session if possible....

Hi, Should I be able to use the Webrick postamble instead of using .campingrc, to tell Camping I want to use mysql? It doesn''t seem to be working for me. It does work however, when I''m using FastCGI (establish_connection :adapter => ''mysql''). James

...ut it through Sweave, I get: http://www.mayin.org/ajayshah/tmp/bugdemo.tex which is, of course, a generic latex file which you can read and run. When I try to use pdflatex, I get the error: ... ... ... (/sw/share/texmf-dist/tex/latex/ae/t1aett.fd) Runaway argument? > prices <- cbind(mydb("macro", "nifty", freq = "w"), mydb("firm.pric\ETC. ! Paragraph ended before \FV at BeginScanning was complete. <to be read again> \par l.60 \end{frame} ? I transplanted the R code from bugdemo.Rnw into an ordinary lat...

I am sure I'm doing something wrong here but not sure what. Our system administrator recently installed UnixODBC and the MyODBC driver on a Linux box running Linux version 2.6 x86_64. I have an .odbc.ini file in my home directory with following lines: [mydb] Description = MySQL server on my-server Driver=/usr/lib64/libmyodbc3.so SERVER=my-server I can successfully do the following: library(RODBC) channel <- odbcConnect("mydb") sqlQuery(channel, "show databases") And in general, I have no problems using odbcConnect to connect...

...t I call with the System()-command or a SHELL()-command) ? Here are some examples from the verbose file. [Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22 15:19:10]     -- Executing [s at sub-GetAlertInfo:3] MYSQL("SIP/SipAgenT01-0000317d", "Connect connid localhost myuser mypwd myDB") in new stack [Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22 15:19:10]     -- Executing [s at sub-GetAlertInfo:5] MYSQL("SIP/SipAgenT01-0000317d", "Query resultid 1 SELECT uri, callinfo FROM distringtone WHERE onoff='1'") in new stack [Aug 22 15:19:18] VERBOSE[3...

Dear list, I learned how to connect R to a local MySQL server, using: drv <- dbDriver("MySQL") con <- dbConnect(drv, user="root", password="mypass", dbname="mydb") Is it possible to connect R in this way to an external server (on a different machine, with a different IP)? I read the documentation on ?dbConnect (and everything I could find on the internet), but I failed to find some other relevant arguments. For example, one needs to first connect...

Buenas, Alguno usa alguno de los paquetes de Microsoft R para la conexion a SQL Server? De ser asi, que paquete y que comandos usais? Yo hasta ahora he usado odbc, de Rstudio, pero me da siempre problemas con el tipo de datos que tiene SQLServer ... Un saludo Jes?s [[alternative HTML version deleted]]

...C++) Max connections: 10 Conn. processed: 8 Default records per fetch: 500 Oracle R/S client version: 0.5-4 RS-DBI version: 0.1-9 Open connections: 2 1 <OraConnection:(6721,0)> 2 <OraConnection:(6721,7)> > > conn <- dbConnect(drv, "mathieu/toto at MYDB") > summary(conn, verbose=TRUE) <OraConnection:(6721,7)> User: mathieu Dbname: MYDB Oracle Server version: > > rs <- dbSendQuery(conn, statement = paste("select * from cat")) > summary(rs, verbose=TRUE) <OraResult:(6721,7,2)> Statement: select *...

Hi there! How can i use 2 database connections in my rails application ( if it''s possible of course ): one for reading from DB and one for writing to DB? Thanks, Dmitry -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To

...;> >> Here are some examples from the verbose file. >> >> >> >> [Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22 15:19:10] -- Executing >> [s at sub-GetAlertInfo:3] MYSQL("SIP/SipAgenT01-0000317d", "Connect >> connid localhost myuser mypwd myDB") in new stack >> [Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22 15:19:10] -- Executing >> [s at sub-GetAlertInfo:5] MYSQL("SIP/SipAgenT01-0000317d", "Query >> resultid 1 SELECT uri, callinfo FROM distringtone WHERE onoff='1'") >> in new s...

I am running R version 2.9.2 on Windows XP OS with RODBC version Version: 1.3-0. Has anyone out there in the R user community successfully appended records to a DB2 table on a remote database using the sqlSave function in the RODBC package? (or by any other means from R?) I posed a similar question a few months ago and unfortunately, did not receive a response. I was hoping recent upgrades to

...;m using MySQL database connections intensively. After a bunch of queries R fails with the following error message: Error in .Call("RS_MySQL_newConnection", drvId, con.params, groups, PACKAGE = .MySQLPkgName) : RS-DBI driver: (could not connect mylogin@mydatabase on dbname "myDB" Without the R profiler this code runs very stable since weeks. Do you have any ideas or suggestions? I tried the following R versions: ___________________________ platform i386-pc-solaris2.8 arch i386 os solaris2.8 system i386, solaris2.8 status...