Hello,
I'am currently experiencing some problems with the odbcCloseAll() and
odbcClose() function. I'm trying to connect an R script to a MySQL 5.0 database
using RODBC1.1-7 and the MySQL ODBC Driver v.3.51 on a Windows XP Machine. At
first everything seems fine. The script connects, reads and
On Fri, 2006-10-27 at 14:30 +0200, Christian Hager wrote:
Hello,
I'am currently experiencing some problems with the odbcCloseAll() and
odbcClose() function. I'm trying to connect an R script to a MySQL 5.0
database using RODBC1.1-7 and the MySQL ODBC Driver v.3.51 on a
Windows XP Machine.
No all queries are finished.
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible
On Fri, 2006-10-27 at 19:04 +0200, Christian Hager wrote:
No all queries are finished.
Then, I don't know. Can you write and send a short code example which
reproduces the problem on your side so we can try to diagnose? The
simpler the code, the more likely you'll get help.
Cheers,
Jerome
--
Dear all,
I'm reading data via the RODBC connection using
odbcConnectExcel. I use sqlFetch(channel, sheetx) to
identify the correct tab. It appears to read the data
without any problems. However, when I exact a portion
of data - the row number specified is 1 less than in
the actual excel file
the row number specified is 1 less than in the actual excel file
At a guess I'd say this is because the row 1 in excel is taken as the
column heads for the data in R
__
R-help@stat.math.ethz.ch mailing list
10:20 PM
To: r-help@stat.math.ethz.ch
Subject: [R] problem with RODBC
Dear all,
I'm reading data via the RODBC connection using
odbcConnectExcel. I use sqlFetch(channel, sheetx) to
identify the correct tab. It appears to read the data
without any problems. However, when I exact