On Tue, 13 Jul 2010, Rodrigo Aluizio wrote:
Hi List, just to know if the issue is only a problem of mine or if it is a
general issue due to the new MS Office pack. I'm using R 2.11.1 32 bits in a
It's a Microsoft muddle, covered in the RODBC manual for the next
release. Note that R-sig-db is the right list for questions about
RODBC, not R-help.
Simply, if you have MS Office 2007/2010 installed, you can only have
its ODBC drivers of the same architecture installed. Nothing to do
with RODBC nor R, and something MS omits to mention on the download
page for the drivers.
Also, the ODBC data sources manager for x64 Windows tells you only
about 64-bit drivers and DSNs. There is a different manager for
32-bit, but it is rather hidden ....
The simplest thing to do is to use 64-bit R. I found this out the
other way round: I have 32-bit Office installed and could not install
the 64-bit ODBC drivers.
The pre-release of RODBC at
http://www.stats.ox.ac.uk/pub/R/RODBC_1.3-2.tar.gz
is only available as a source package, but you can unpack it and read
the updated manual.
Windows 7 x64 with the MS office 2010 x64 installed. I can import .xls files
normally (the same way I did with my Excel 2007 32 bits). But the function
odbcConnectExcel2007 isn't able to import .xlsx files now that I have the
new version of the Office package.
It gives me the following warning message, which make impossible the
importing process through sqlFetch:
Warning messages:
1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :
[RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
Manager] Nome da fonte de dados n??o encontrado e nenhum driver padr??o
especificado (Source name not found and no default driver specified)
2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :
ODBC connection failed
I'm obviously bypassing it converting my .xlsx files to .xls.
Well the question is simple. Is this an expected issue, like the one when
the xlsx format was released and it will be worked out, or I'm having and
specific problem at one of my system components (drivers)?
Thank you very much for the attention.
Rodrigo Aluizio
[[alternative HTML version deleted]]
--
Brian D. Ripley, rip...@stats.ox.ac.uk
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UK Fax: +44 1865 272595
______________________________________________
R-help@r-project.org 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 code.