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.
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
--
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
Well you have not given us anything to go on really. Are there more than 94
columns? Does each column have a valid fieldname? RODBC is not guaranteed to
work in every possible scenario. If you have a look through the list you will
find there are specific limitations which are not immediately
