: Wednesday, March 25, 2020 12:39 PM
To: Doran, Harold
Cc: r-help@r-project.org
Subject: Re: [R] RODBC Multiple Results
⛔
The City's email systems have identified this email as potentially suspicious.
Please click responsibly and be cautious if asked to provide sensitive
information.
You might wish
You might wish to post this on r-sig-db if you do not get a
satisfactory reply here.
Also, have you checked the databases task view on :
https://cran.r-project.org/ ?
Bert Gunter
"The trouble with having an open mind is that people keep coming along
and sticking things into it."
-- Opus (aka
I'm calling a stored procedure that returns multiple tables and my current
framework uses RODBC and sqlQuery() to communicate between R and the databases
we connect to. A new stored procedure returns multiple tables and I found this
on SO indicating that RODBC "may not" be able to retrieve
Hi,
Sincere apologies if my mail is inappropriate for this mailbox. Please
ignore the mail.
*Issue*
I am getting error "*first argument is not an open RODBC channel*" when I
publish my application on IIS. It runs perfectly under Visual Studio
development mode and the script runs fine on R
Diaz,
paste() and paste0() will work here. paste0() defaults to between character
vector elements and paste() defaults to (single blank character) between
character vector elements. See ?paste.
I do not recall, but you may have to escape the symbol, but that is another
topic.
Try this.
Hi every one
first I would like to introduce myself, as I'm new here.
I'm Luis from Barcelona, I'm Oracle dba and I need to create some nice
graphs.
So, I was looking for a solution and I saw R...
I think it's a good tool to make the task I need.
So here is the task: I need to get all the dblink
On Mon, Apr 20, 2015 at 5:59 AM, CHIRIBOGA Xavier xavier.chirib...@unine.ch
wrote:
Dear members,
What can I do if I get this message: ?
library(RODBC)
Error in library(RODBC) : aucun package nommé ‘RODBC’ n'est trouvé
Thanks in advcance,
Xavier
If I understand the message correctly,
Dear members,
What can I do if I get this message: ?
library(RODBC)
Error in library(RODBC) : any package called ‘RODBC’ was found
Thanks in advcance,
Xavier
__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
On 20/04/2015 7:01 AM, CHIRIBOGA Xavier wrote:
Dear members,
What can I do if I get this message: ?
library(RODBC)
Error in library(RODBC) : any package called ‘RODBC’ was found
That means that you haven't installed it. You need to run
install.packages(RODBC)
first. Depending
Dear Xavier,
Perhaps, you should read the faq:
http://cran.r-project.org/doc/FAQ/R-FAQ.html
And also un livre en français sur R* : R pour les débutants *par Emmanuel
Paradis ou *Introduction à R par *Julien Barnier
install.packages(RODBC)
Un dernier petit mot : Méfiez vous! La patience des
Install it with
install.packages(RODBC)
Best,
Ista
On Apr 20, 2015 7:02 AM, CHIRIBOGA Xavier xavier.chirib...@unine.ch
wrote:
Dear members,
What can I do if I get this message: ?
library(RODBC)
Error in library(RODBC) : any package called ‘RODBC’ was found
Thanks in advcance,
Dear members,
What can I do if I get this message: ?
library(RODBC)
Error in library(RODBC) : aucun package nommé ‘RODBC’ n'est trouvé
Thanks in advcance,
Xavier
__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
Just an update
This error can be reproduced with:
Windows system without MS Office (especially Excel) and an Excel file
with graphs inside a sheet. It does not depend whether this sheet is
used or not for import.
Knut
__
R-help@r-project.org
There is a system wide installation for the university computer of r and
Rcmdr (R-Commander)
There a a few computer with the following message the user tries to open
an excel sheet with R.Commander:
(I assume the german message is from the german operating system win 7)
library(RODBC,
Hi guys,
I am running a simple R script using RODBC that follows:
library(RODBC)
ch - odbcConnect(con)
cust- sqlQuery(ch, select
id_customer,
first_name
from
customers
limit 100)
sales- sqlQuery(ch, select
id_order,
revenue
from
sales
limit 100)
-
And it
con is probably not a valid ODBC DSN. You need to study how ODBC works
independently of R... we cannot tell you what you should be putting there
instead.
---
Jeff NewmillerThe . .
On Jun 6, 2014, at 8:45 AM, Jeff Newmiller wrote:
con is probably not a valid ODBC DSN. You need to study how ODBC works
independently of R... we cannot tell you what you should be putting there
instead.
But what ever would be the correct answer, it should not segfault. I'm
reasonable
Oh, forgot telling the specifications:
R version 3.0.2 (2013-09-25)
Platform: x86_64-pc-linux-gnu (64-bit)
Database: Mysql
ODBC Connector: libmyodbc
I've configured ODBC Connection using this hot-to:
https://help.ubuntu.com/community/ODBC
--
View this message in context:
Dear All,
I just wanted to follow up my question with an answer, which I owe to Robbie
Bingler at UVA's IATH. The code chunk that bombed is here:
sqlQuery(DRCch,paste(
+ SELECT *
+ FROM tblCeramicWare
+ ))
[1] 42P01 7 ERROR: relation \tblceramicware\ does not
meddelelse
Fra: Fraser D. Neiman
Dato:30/05/2014 21.27 (GMT+01:00)
Til: r-help@r-project.org
Emne: [R] RODBC and PosgreSQL problems
Dear All,
I am trying for the first time to run SQL queries against a remote PostgreSQL
database via RODBC. I am able to establish a connection just fine
-help@r-project.org Subject: [R] RODBC and PosgreSQL problems
Message-ID:
2176ad174d58cb4abbda99f3458c20171be55...@granger.monticello.org
Content-Type: text/plain
Dear All,
I am trying for the first time to run SQL queries against a remote
PostgreSQL database via RODBC. I am able to establish
Dear All,
I am trying for the first time to run SQL queries against a remote PostgreSQL
database via RODBC. I am able to establish a connection just fine, as shown by
getting results back from the sqlTables(), sqlColumns() and sqlPrimary Key()
functions in RODBC. However, when I try to run a
When i am running a *DELETE * query on MS SQL database I am getting
*[RODBC] ERROR: Could not SQLExecDirect * error. I am getting this error for
the DELETE query that requires more time.
Please suggest workarounds if any.
Thanks
--
View this message in context:
iODBC appears no longer to come standard with OSX, so I installed unixodbc and
set it up following instructions here:
http://www.boriel.com/en/2013/01/16/postgresql-odbc-connection-from-mac-os-x/
I connected to my remote database with isql -v mydsn. No problem. Then I tried
from R:
iODBC appears no longer to come standard with OSX, so I installed unixodbc and
set it up following instructions here:
http://www.boriel.com/en/2013/01/16/postgresql-odbc-connection-from-mac-os-x/
I connected to my remote database with isql -v mydsn. No problem. Then I tried
from R:
Hi All,
There's a function called setSqlTypeInfo(driver,value) in RODBC package
http://cran.r-project.org/web/packages/RODBC/index.html
Description
Specify or retrieve a mapping of R types to DBMS datatypes.
From the package(RODBC) TypeInfo.r:
setSqlTypeInfo - function(driver, value)
{
Hello,
I want to leave pwd blank (to comply w/ company security protocol) and just be
prompted by the driver-specific data source dialog box to enter the password
after. But for some reason it is not working.
R Version: R version 2.15.1 (2012-06-22)
R Studio Version: 0.97.312
OS: Windows 7
Daniel,
Thanks for letting me know.
I'll try it w/o Rstudio if needed.
Thanks.
Dan
-Original Message-
From: Daniel J. Robertson [mailto:dj...@cornell.edu]
Sent: Monday, April 22, 2013 1:51 PM
To: Lopez, Dan; R help (r-help@r-project.org)
Subject: RE: [R] RODBC --How do you set up
-Original Message-
From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On
Behalf Of Lopez, Dan
Sent: Monday, April 22, 2013 4:41 PM
To: R help (r-help@r-project.org)
Subject: [R] RODBC --How do you set up the connection so pwd is blank but
driver-specific data source dialog
Greetings:
I am trying to query an MSSQL database which contains time series data
using RODBC.
Using Server Management Studio, I can retrieve the data with this query:
Select * from tb_ace_mag_1m where time_tag='2012-01-08 00:00:00' AND
time_tag'2012-01-08 03:00:00'
However, when I try to
The RODBC installation failed, with the following message ( 2 missing c header
files ):
checking for sqlext.h... no
configure: error: ODBC headers sql.h and sqlext.h not found
ERROR: configuration failed for package âRODBCâ
* removing â/home/hadoop/R/i686-pc-linux-gnu-library/2.15/RODBCâ
On Mar 11, 2013, at 1:12 PM, jefe goode jefe_go...@yahoo.com wrote:
The RODBC installation failed, with the following message ( 2 missing c
header files ):
checking for sqlext.h... no
configure: error: ODBC headers sql.h and sqlext.h not found
ERROR: configuration failed for package
I've got a data.frame I'm trying to insert into a database table in an
ms sql server instance using RODBC. When I save a table using
nothing but character and numeric columns things work fine. However,
when I attempt to add another column of type POSIXct to the data.frame
and redefine the table
Follow up.
After lots of hours around this i got a fix:
1) Deinstalled Java
2) Downloaded the R Source
3) Configured . oraenv
4) Made sure the libsqora.so.11.1 was on the LD_LIBRARY_PATH
5) compiled from the source with the standard ./configure and make make
install
After this RODBC started
Is this a bug:
Trying to update when the where condition gives zero rows throws an error on MS
SQL server
sqlQuery(pipe,select * from ComDetailCurrent where RateTypeId is null;)
[1] ProcessDate SourceSystemIdAccountNumber Xref1
0 rows (or 0-length row.names)
into R.
RODBC works great as long as the other user has not open the file. I tried:
channel - odbcConnectExcel2007(Biosample.xlsx)
channel - odbcConnectExcel2007(Biosample.xlsx,readOnly = TRUE)
but I do get a windows error message that the file is locked by another
user.
Is there a way to open
into R.
RODBC works great as long as the other user has not open the file. I tried:
channel - odbcConnectExcel2007(Biosample.xlsx)
channel - odbcConnectExcel2007(Biosample.xlsx,readOnly = TRUE)
but I do get a windows error message that the file is locked by another
user.
Is there a way to open
On Jul 4, 2012, at 10:10 AM, Lorcan Treanor wrote:
Dear Sir/Madam,
I am desperately in need of some help. I am trying to access tables from
the oracle database and inserting them into R via a data frame and I keep
getting an error saying that Error in .Call(C_RODBCFetchRows,
attr(channel,
Dear Sir/Madam,
I am desperately in need of some help. I am trying to access tables from
the oracle database and inserting them into R via a data frame and I keep
getting an error saying that Error in .Call(C_RODBCFetchRows,
attr(channel, handle_ptr), max, buffsize, :
negative length vectors
Hi, I have tried to figure this out from the help files and lists but not
managed it
I can access a local MySQL database from R running on my Windows XP PC. What I
want to do is access a MySQL database on a linux web server, for which I have
admin access. I can't figure out how to set up
On 21/06/2012 17:17, Brett Robinson wrote:
Hi, I have tried to figure this out from the help files and lists but not
managed it
I can access a local MySQL database from R running on my Windows XP PC. What I
want to do is access a MySQL database on a linux web server, for which I have
admin
Hello Brett,
My guess is you did not set the access rules on the MySQL server to
allow connections from this host.
Take care
Oliver
On Thu, Jun 21, 2012 at 1:29 PM, Prof Brian Ripley
rip...@stats.ox.ac.uk wrote:
On 21/06/2012 17:17, Brett Robinson wrote:
Hi, I have tried to
On 29.05.2012 17:27, Steven Lacey wrote:
Hi,
I am hoping to use the RODBC package to write a dataframe to an Excel .xlsx
file. The dataframe contains at least one field with character elements
that exceed 255 bytes, which appears to be the cell width limit in Excel.
Below is example code and
Hi,
I am hoping to use the RODBC package to write a dataframe to an Excel .xlsx
file. The dataframe contains at least one field with character elements
that exceed 255 bytes, which appears to be the cell width limit in Excel.
Below is example code and the warning message received:
If you're using (R)ODBC, you need a workflow that is either 32bit or
64-bit, but not mixed.
On a 64-bit Windows 7 machine, I can use 32-bit R and RODBC to read
and write 32-bit Excel (etc) and similarly xlsreadwrite works 32-bit.
I can use 64-bit R and XLConnect to read and write from excel
On Sun, Dec 4, 2011 at 9:40 AM, andrija djurovic djandr...@gmail.com wrote:
Hi to all.
I have a problem to connect to an Excel database using RODBC.
There are tips for RODBC as well as some alternatives listed here:
http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows
--
Statistics
andrija djurovic djandrija at gmail.com writes:
Hi to all.
..
Thanks in advance
Andrija
I am having the exact same problem. Any luck with this yet?
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE
This question might better be asked on r-sig-db or r-sig-mac (I am not
sure which one would better, but please not both).
-Don
--
Don MacQueen
Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062
On 4/29/12 7:08 AM, julia.jacob...@arcor.de
Unfortunately, I'm not really making any progresses, despite a lot of effort.
I've compiled R on Mac OS X for myself using MacPorts and the error is now
state 28000, code 201 which is failed password authentification.
__
R-help@r-project.org mailing
of an old patch present in
cygwin-ports:
http://cygwin-ports.git.sourceforge.net/git/gitweb.cgi?p=cygwin-ports/R-RODBC;a=summary
I would like to point out that R is now part of the std cygwin
packages: http://cygwin.com/packages/
In using R under cygwin just because I found that combining R
I thought that maybe installing the RODBC package from source might fix the
problem:
install.packages(RODBC,type=source)
but to no success.
RODBC still gives the same warning with the same error code and very little
information to tackle the problem.
On Apr 25, 2012, at 10:03 AM,
Hello everybody out there using the RODBC package,
On my linux (unixODBC) and windows machines, I can successfully use the RODBC
package to connect to a PostgreSQL databse.
On my Mac Book running Mac OS X 10.6 (Intel 64bit architecture), I get the
error code 202 and message ? when I try to
On Apr 25, 2012, at 10:03 AM, julia.jacob...@arcor.de wrote:
Hello everybody out there using the RODBC package,
On my linux (unixODBC) and windows machines, I can successfully use the RODBC
package to connect to a PostgreSQL databse.
On my Mac Book running Mac OS X 10.6 (Intel 64bit
in!
From: matthew-c.john...@ubs.com matthew-c.john...@ubs.com
Cc: r-help@r-project.org
Sent: Friday, February 17, 2012 12:48 AM
Subject: RE: [R] RODBC sqlSave / append problem (windows XP, R 2.13.2)
Hi Taby,
Â
i could not work out how to add to a table, so what i
did was to kill the old one
This was my experience connecting remotely to an Oracle database with R 64
bit on Windows 7 64-bit. I already had a configuration for 32-bit R and
32-bit Oracle using RODBC that worked, but I wanted to only use R-64. Here
was what I did that works:
This was assuming an install to the root c:\ and
: mattjo matthew-c.john...@ubs.com
To: r-help@r-project.org
Sent: Monday, December 5, 2011 1:25 AM
Subject: [R] RODBC sqlSave / append problem (windows XP, R 2.13.2)
Dear All,
Using RODBC I have read in a (429 x 11) dataframe from Access, and would
like to append two columns of transformed data
,as.data.frame(__myDF__),tablename=__mytable__,rownames=T,f
ast=T)
odbcClose(con) #Close connection to DB
best regards
mj
From: taby gathoni [mailto:tab...@yahoo.com]
Sent: 16 February 2012 23:29
To: Johnson, Matthew-C
Cc: R help
Subject: Re: [R] RODBC sqlSave
I have a problem with RODBC statements that seems to be related to inserting
data into a table during an SQL batch (MS SQL Server). It started from a
stored procedure that didn't return data to R but I could boil it down to
the following simplified code snippets.
The first one does work:
Hi
one col in my Excel file contains many numbers. But on line 3000 and
some other lines are strings like FG 1. RODBS seems to omit this
lines. gdata works, but is much slower.
Is this a bug of RODBC or do I apply it wrong?
Example with the same file.xlsx
library(RODBC); excel -
Hi Christof,
have a look at the manual of RODBC, and in particular the section on
Excel drivers.
RShowDoc(RODBC, package=RODBC)
Regards,
Enrico
Am 09.01.2012 19:02, schrieb Christof Kluß:
Hi
one col in my Excel file contains many numbers. But on line 3000 and
some other lines are
Hi Enrico,
thank you very much, so it is a known problem with the Microsoft Excel
ODBC drivers :(
7 Excel Drivers
... There are at least two known problems with reading columns that do
not have a format set before data entry, and so start with format
`General'. First, the driver uses the first
On 9 January 2012 10:46, Christof Kluß ckl...@email.uni-kiel.de wrote:
thank you very much, so it is a known problem with the Microsoft Excel
ODBC drivers :(
As I was advised a few weeks ago, the best way for Excel to get into R
is to export the file as CSV and use read.csv, read.csv2, or
You could prepare the data in Excel as text, and then coerce them to
numeric in R (and approriately code your FG 1 strings).
Depending on how large your file is, you could create a new file, format
the cells as text, and then copy the data into this new file. Or change
cell entries to text
; it is very flexible.
From: Enrico Schumann enricoschum...@yahoo.de
To: Christof Kluß ckl...@email.uni-kiel.de
Cc: r-h...@stat.math.ethz.ch
Sent: Monday, 9 January 2012, 20:28
Subject: Re: [R] RODBC vs gdata
You could prepare the data in Excel as text
On Mon, Jan 9, 2012 at 1:02 PM, Christof Kluß ckl...@email.uni-kiel.de wrote:
Hi
one col in my Excel file contains many numbers. But on line 3000 and
some other lines are strings like FG 1. RODBS seems to omit this
lines. gdata works, but is much slower.
Is this a bug of RODBC or do I apply
Hi Gregory,
See below.
On Jan 5, 2012, at 4:20 PM, gregory benison wrote:
As Duncan noted, the message is pretty clear in that the ODBC header files
are missing, which are required to compile RODBC from source. On RH based
Linuxen, this requires the installation of the unixODBC-devel RPM,
1. If you do not have unixODBC installed, you will get an error message
regarding a missing ODBC driver manager, if as you have done here, that test
is first rather than second.
If the test for the headers comes first, and no driver manager is
installed, configure exits with an error before
As Duncan noted, the message is pretty clear in that the ODBC header files
are missing, which are required to compile RODBC from source. On RH based
Linuxen, this requires the installation of the unixODBC-devel RPM, much as
one would need to have other *-devel RPMs (eg. readline-devel)
On 12-01-03 2:39 PM, gregory benison wrote:
If one attempts to install RODBC (via install.packages('RODBC'))
without having an ODBC driver installed, this error message results:
checking sqlext.h presence... no
checking for sqlext.h... no
configure: error: ODBC headers sql.h and sqlext.h not
Le mardi 03 janvier 2012 à 11:39 -0800, gregory benison a écrit :
If one attempts to install RODBC (via install.packages('RODBC'))
without having an ODBC driver installed, this error message results:
checking sqlext.h presence... no
checking for sqlext.h... no
configure: error: ODBC headers
On Jan 4, 2012, at 8:02 AM, Milan Bouchet-Valat wrote:
Le mardi 03 janvier 2012 à 11:39 -0800, gregory benison a écrit :
If one attempts to install RODBC (via install.packages('RODBC'))
without having an ODBC driver installed, this error message results:
checking sqlext.h presence... no
One thing R could do better is to provide a standard way to view README and
similar files before installing a package. That might have helped here.
Agreed... right now, the R documentation points to a straightforward,
one-line way to download and install packages from the R command line,
but
If one attempts to install RODBC (via install.packages('RODBC'))
without having an ODBC driver installed, this error message results:
checking sqlext.h presence... no
checking for sqlext.h... no
configure: error: ODBC headers sql.h and sqlext.h not found
ERROR: configuration failed for package
I am trying to connect to an internal database and use the sqlQuery command to
reduce and retrieve data using the following code:
channel -odbcConnect(some_dsn, uid=, pwd=)
txt-'SELECT Date, Region, Price FROM TableXYZ WHERE Type=Domestic'
sqlQuery(channel, cat(txt,\n),errors=TRUE,)
On 20.12.2011 14:55, Mike Pfeiff wrote:
I am trying to connect to an internal database and use the sqlQuery command to
reduce and retrieve data using the following code:
channel-odbcConnect(some_dsn, uid=, pwd=)
txt-'SELECT Date, Region, Price FROM TableXYZ WHERE Type=Domestic'
be asking what is the proper way to return inside of a char
string?
-Original Message-
From: Uwe Ligges [mailto:lig...@statistik.tu-dortmund.de]
Sent: Tuesday, December 20, 2011 8:46 AM
To: Mike Pfeiff
Cc: 'r-help@r-project.org'
Subject: Re: [R] RODBC Error: 'getCharCE' must be called
.
Uwe ligges
-Original Message-
From: Uwe Ligges [mailto:lig...@statistik.tu-dortmund.de]
Sent: Tuesday, December 20, 2011 8:46 AM
To: Mike Pfeiff
Cc: 'r-help@r-project.org'
Subject: Re: [R] RODBC Error: 'getCharCE' must be called on a CHARSXP
On 20.12.2011 14:55, Mike Pfeiff wrote
Hi All,
I am pretty new for RODBC. I want to save my table to a DB, so I
used something like
sqlSave(db, a, 'Forecast_Result', rownames = FALSE);
But I got an error
Error in sqlSave(db, a, Forecast_Result, rownames = FALSE) :
table 'Forecast_Result' already exists
Yes, that
Hi to all.
I have a problem to connect to an Excel database using RODBC.
Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following:
library(RODBC)
channel - odbcConnectExcel(results.xlsx)
Error in odbcConnectExcel(results.xlsx) :
odbcConnectExcel is only usable with 32-bit
Do you need to use RODBC specifically? I've been using XLConnect quite a lot
recently and have been quite pleased with it.
Michael
On Dec 4, 2011, at 9:40 AM, andrija djurovic djandr...@gmail.com wrote:
Hi to all.
I have a problem to connect to an Excel database using RODBC.
Namely, I am
Hi. Not specifically, but I used it before with 32-bit R under Windows XP
and it worked just fine so i though to keep using it.Anyway I will lookt at
XLConnect.
Thank you for suggestion.
Andrija
On Sun, Dec 4, 2011 at 7:41 PM, R. Michael Weylandt
michael.weyla...@gmail.com
Dear All,
Using RODBC I have read in a (429 x 11) dataframe from Access, and would
like to append two columns of transformed data (429 x 2) to the original
table (thereby making it a 429 x 13 table). I would ideally like this to
be the same name etc as the original table in Access.
I have used
Hola,
Alguno ha usado el paquete RODBC para acceder a una BBDD MySQL desde R en
Windows?
Qu'e mas tengo que hacer a parte de:
1) Aniadir el Driver de MySQL a la lista de User DSN en Control panel -
Administrative tools - Data Sources(ODBC)
2) Testear que funciona la conexion
2) Ejecutar: ch -
On 15.11.2011 14:34, Usuario R wrote:
Hola,
Alguno ha usado el paquete RODBC para acceder a una BBDD MySQL desde R en
Windows?
Qu'e mas tengo que hacer a parte de:
1) Aniadir el Driver de MySQL a la lista de User DSN en Control panel -
Administrative tools - Data Sources(ODBC)
2) Testear
Thanks a bunch, it was driving me nuts. My experience would seem to confirm
yours. Thanks to your post, I fixed a database update that was crashing my
R session. I changed the data column that I was posting from a POSIXct to a
Date, and now the data goes in. That works fine for me since my
Hello all!
Can someone confirm whether there is a bug or not?
I was trying to use sqlUpdate in place of sqlSave as data set I import has
duplications. However I get errors while using fast=FALSE argument to safely
update/ignore duplicates:
Error while executing the query[RODBC]
frame I’m pushing to DB:
class(dat$time)
[1] POSIXct POSIXt
Mikhail
-Original Message-
From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org]
On
Behalf Of Mikhail Titov
Sent: Sunday, August 07, 2011 7:22 PM
To: r-help@r-project.org
Subject: [R] RODBC: sqlUpdate
[mailto:r-help-boun...@r-project.org]
On
Behalf Of Mikhail Titov
Sent: Sunday, August 07, 2011 7:27 PM
To: r-help@r-project.org
Subject: Re: [R] RODBC: sqlUpdate doesn't handle properly POSIXct field?
I apologize for the first e-mail as I didn't use plain text. Here is the
full message.
--8
Hello,
After a (bad) first try some months ago, I'm trying again to use RODBC
package instead of DBI+RMySQL packages to populate MySQL database.
The main command is
sqlSave(channel, data_df, tablename, append=T, rownames=FALSE,
colnames=FALSE, fast=FALSE, varTypes=vartypes)
where data_df is the
I've just tested with 12 figures instead of 13. And it works ...
But I'm not able to modify these numbers as they are codes given by other
guys (and women as well) to distinguish equipments.
And I thought the limit with R was 15 digits and not 13.
Is it a (bad for me) special feature of the
Why don't you read/write this field as a character string? Pretty common for
codes.
2011/7/27 PtitBleu ptit_b...@yahoo.fr
I've just tested with 12 figures instead of 13. And it works ...
But I'm not able to modify these numbers as they are codes given by other
guys (and women as well) to
In fact, I always use a string for ID variables because you can get
some funky matching errors due to mismatches in precision.
Bill Gould at Stata Corp said this well in a recent blog post
1. Use theory to check IDs if they are numeric
One way the id variable can become corrupted is if it is not
I spent all the day on this problem and I've just finally found a solution:
with options(digits=13), it now works.
If I hadn't found this, I would have used the solution of Renaud (but not
very convenient to me).
Nice end of day,
(Happy) Ptit Bleu.
--
View this message in context:
I'm trying to export a data frame to Excel using the RODBC sqlSave function. I
don't want the colnames, so I use the colnames=F option. Unfortunately, the
column names still show up as the first row in my spreadsheet. If I set the
colnames=T, then the column names show up in BOTH rows 1 and 2.
Hello,
How can I tell RODBC to scan all the records of an xls file to determine the
data type? If the first n records happen to be empty Rodbc assumes a character,
and any numbers are made NA. And if, for instance, the first n records
contain
numbers, and later they also contain characters,
This is not a decision being made by RODBC... it is in the Microsoft ODBC
driver for Excel. If you really want to know more, you can read
http://www.dicks-blog.com/archives/2004/06/03/external-data-mixed-types/ ...
but the best solution is to take your data out of Excel and only use xls/xlsx
water system, and public health, what have
the
Romans ever done for us?
~~
From: Jeff Newmiller jdnew...@dcn.davis.ca.us
Sent: Tue, May 3, 2011 10:21:02 AM
Subject: Re: [R] Rodbc quesion: how
On May 3, 2011, at 2:10 AM, Albert-Jan Roskam wrote:
Hi Jeff,
Ah, thanks a lot! Yes, meanwhile I also switched to csv. This still
requires
knowledge about the regional settings (Sys.getlocale), but it's a
lot more
transparent.
I'm quite new to R and I must say that stuff like this is
I've had the same problem and ended up using the xlsReadWrite package. It
takes more time to import a sheet but does have the colClasses command.
Following your example:
library(xlsReadWrite)
read.xls(testtable, sheet = sheet1, colClasses=character)
should worked, it did for me
--
View this
Hi All,
I'm using RODBC to tap into MySQL on a remote server. It appears like
the connection is successful: I can see all tables and columns in my
database. However, queries return zero lines, including queries I've
verified as functional and non-empty by entering them directly in
MySQL.
I
1 - 100 of 258 matches
Mail list logo