search for: dbcon

...nnection automatically on startup of R? (Making sure of course that the db server has been started...) I am running MySQL on Mac OS X 10.4.2 with R2.4.1. I have tried to write a function using the RMySQL commands (below) and place them in .First of .RProfile: drv <- dbDriver("MySQL") dbcon <- dbConnect(drv, {other parameters present in my.cnf file} dbname="mydbName") DOES create a connection when entered into my R console individually but NOT when I place them in a function, i.e., condb <- function() { drv <- dbDriver("MySQL") dbcon <- dbConnect(dr...

...re are a bunch of different data types. Instead of guessing which data types are being used, I simply query the database and grab the data types (this will work even if the database has columns but is empty), then use this information when populating. In short, I do the following: library(RODBC) dbCon <- odbcConnect(db) tmp <- sqlColumns(dbCon, dbTable) ## this function grabs a bunch of info about the columns) varTypes <- as.character(tmp$TYPE_NAME) names(varTypes) <- as.character(tmp$COLUMN_NAME) sqlSave(dbCon, dataSet, dbTable, append=TRUE, rownames=FALSE, varTypes=varTypes) The &...

Dear R-users, First, thank you to the developers for the very useful R-library RMySQL. While using this library a recieved an error message: RS-DBI driver: (could not run statement: Too many columns) The statement that generated the error was: dbWriteTable(dbcon, "simdataseries", template, overwrite = TRUE, row.names = FALSE ) I am assuming this is a RMySQL rather than MySQL limit. If that is the case I was wondering just what this limit is and if it is possible to raise it? Thanks again for all the hard work. Sincerely Mark -- Mark Van De Vy...

Hi, I use the ROracle interface in the R 64bit version. When I fetch a large number of rows from the database I get alternating 250 rows of what I want to see and than 250 rows junk and so on. It does not matter whether I use the fetch command or dbGetquery or whatever. My fetch_default_rec = 500 and I can not change it by setting it explicitly in Oracle(). Any idea what's the problem

...for non-ASCII characters ... WARNING Found the following files with non-ASCII characters: all.R Portable packages must use only ASCII characters in their R code, except perhaps in comments. 2. * checking whether the name space can be loaded with stated dependencies ... WARNING Error in initDbConnection() : could not find function "dbConnect" Error: .onLoad failed in ''loadNamespace'' for ''pd.ragene.1.0.st.v1'' Execution halted A namespace must be able to be loaded with just the base namespace loaded: otherwise if the namespace gets loaded by a sav...

Hola Javier, si no estoy entendiendo mal, lo q deseo hacer no se trata de configurar los parametros SQL, sino solo de colocar un vector en el argumento VarTypes de la funcion sqlSave. El manual especifica esa opcion, pero no da ningun ejemplo de como usarla. *varTypes an optional named character vector giving the DBMSs datatypes to be used for* *some (or all) of the columns if a table is to be

...ing MySQL Database in R Message-ID: <alpine.OSX.2.00.1101220856040.18654@dngan> Content-Type: TEXT/PLAIN; charset=UTF-8; format=flowed I think this is not an R issue, but one of MAMP. On my server's sql service, I can connect using password, however, on my local MAMP, I need the socket: dbCon <- dbConnect(dbdr, user="root", password="root", dbname="mydb", unix.socket="/Applications/MAMP/tmp/mysql/mysql.sock") HTH, *S* On 11-01-20 08:30, Spencer Graves wrote: > The following worked for me recently: > > > library(RMySQL) &gt...