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]]

