On 1 March 2006 at 22:30, Dirk Eddelbuettel wrote:
| Did you try setting believeNRows=FALSE in odbcConnect() ? From
| help(odbcConnect, package=RODBC):
[...]
| odbcConnect(dsn, uid = "", pwd = "", case = "nochange",
| believeNRows = TRUE)
| [...]
| believeNRows: logical. Is the number of rows returned by the ODBC
| connection believable? Not true for Oracle and Sybase,
| apparently.
|
| This has been the fix on other systems, it could simply that RODBC gets
| handed a bad value. Apparently common with some backends, as I recall I had
| to use that too with some Sybase-on-Solaris versions a while back.
I really meant FALSE, not TRUE:
On 2 March 2006 at 10:00, Johannes Ranke wrote:
| Package: r-cran-rodbc
| Version: 1.1.5-1
| Followup-For: Bug #354723
[...]
| [EMAIL PROTECTED]:~$ cat odbctest.R
| library(RODBC)
| channel <- odbcConnect("cytotox",uid="cytotox",
| pwd="cytotox", believeNRows=TRUE)
^^^^^^^^^^^^^^^^^^
| query <- "SELECT plate FROM plates LIMIT 1,10"
| tables <- sqlQuery(channel,query)
| tables
| odbcGetErrMsg(channel)
| odbcClose(channel)
So could you please try with FALSE?
Otherwise, I agree with a comment you made in the another mail that it is
probably the myodbc driver that causes it. RODBC only passes the command on.
Dirk
--
Hell, there are no rules here - we're trying to accomplish something.
-- Thomas A. Edison
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
