search for: odbcgeterrmsg

...dea to prevent Dr. Watsons, even if it is triggered by a stupid user, as in my case. (1, may be Davids comment already solves this?) There are still some problems with sqlTables() and sqlQuery() which should return a data.frame, but only return one line. I tried with MS Access and Oracle, and now odbcGetErrMsg() somewhat explains the problem. sqlTables(0) TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE REMARKS 1 C:\\TEMP\\db NA MSysACEs SYSTEM TABLE NA Browse[1]> odbcGetErrMsg(channel) [1] "[RODBC]ERROR: Row count not supported" Why is this? If it is generally pos...

...2003-12-15 00:00:00 7 2003-12-15 00:00:00 8 2003-12-15 00:00:00 9 2003-12-15 00:00:00 ??Which is the mistake?. And the second question is the command odbcFechRows() don't work, for example if write tbl<-odbcFetchRows(canal) in place of sqlFetch result a error stat = -1 and the list is NULL odbcGetErrMsg return No results available. Thank Ruben

...ta) anotherDatabaseOperation(db, data2) # This often fails b/c the db is no longer open. odbcClose(db) } I see some output: Warning: closing unused RODBC handle 9 Warning: [RODBC] Error SQLDisconnect Warning: [RODBC] Error SQLFreeconnect Warning: [RODBC] Error in SQLFreeEnv Error in odbcGetErrMsg(channel) : first argument is not an open RODBC channel I suspect that during the call to someLongCalculation(), R considers the database connection as "unused", and therefore, closes the connection, which prevents me from using the connection in the call to anotherDatabaseOperation(). W...

...blename) : USArrests : table not found on channel Check case parameter in odbcConnect > sqlSave(channel, USArrests, rownames = "state", addPK=TRUE) Error in sqlSave(channel, USArrests, rownames = "state", addPK = TRUE) : [RODBC] ERROR: Could not SQLExecDirect > odbcGetErrMsg(channel) character(0) > sqlTables(channel) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 opus usarrests TABLE MySQL table --------------------------------------------------------------------- The next thing I did was to check from the MySQL commandline...

...where is_test = '%d' and is_pos = '%d' and ora_hash(txn.seq_no,%d,%d)=0" dbConn = odbcConnect("mysid",uid="myuser",pwd="mypass",case="toupper",believeNRows=FALSE) tfg = sqlQuery(dbConn, sprintf(sqlTxnFvs,0,0,1/sratg-1,seeds[i])) dbErr = odbcGetErrMsg(dbConn) All of the tables except mddsg100bp are IOT tables (index organized tables aka clustered index in MSSQL). I set the believeNRows=FALSE. I tried increasing the ODBC DSN config buffer from the default 64k to first 5M and then 10M. I started with columns from the narrower table mcc.* (38) a...