Dear list,
this is my first question at this place, so I hope I do things right.
I am working with R 2.9.2 on WinXP, trying to access a large non-relational
database (PI by Osisoft) holding process data. PI comes with an ODBC driver
which I try to use. The Problem is that SQL-Queries return the right column
names but never any values (no rows).
Checking with my IT support I have tracked the problem down to the command
"SQLFetchScroll" which is used by R (part of ODBC version 3) whereas the ODBC
driver supports ODBC version 2 only:
"So it appears that the execution engine uses SQLFetchScroll, but this is a
function introduced with ODBC 3. PI ODBC is compliant to version 2, so the
script fails when attempting to call SQLFetchScroll with the error:
[Microsoft][ODBC Driver Manager] Driver does not support this function (0)."
Is there a way to use RODBC in a compatibility mode with older versions of ODBC?
Regards,
Richard Kiefer
-------------------------------------------------------
Richard Kiefer
Dr. rer. nat.
RWE Power AG
Asset Management
Einsatzoptimierung
Altenessener Str. 27
45141 Essen
----------------------------------------------------------------
Irgendwann kommt jeder drauf! WWW.ENERGIEWELT.DE
-----------------------------------------------------------------------------------
Vorsitzender des Aufsichtsrates: Dr. Rolf Martin Schmitz
Vorstand: Dr. Johannes Lambertz (Vorsitzender),
Prof. Dr. Gerd Jaeger, Antonius Voss,
Erwin Winkel
Sitz der Gesellschaft: Essen und Koeln
Eingetragen beim Amtsgericht Essen
Handelsregister-Nr. HRB 17420
Eingetragen beim Amtsgericht Koeln
Handelsregister-Nr. HRB 117
[[alternative HTML version deleted]]
______________________________________________
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.
