Hi.

I attempted to use RODBC and decided to execute all the tests provided in "Test.r" under the unpacked package RODBC folder.

Beginning with the following:
library(RODBC)
library(MASS)
USArrests[1,2] <- NA
hills <- hills[1:15,]
row.names(hills)[12] <- "Dollar ('$')"
set.seed(1)

# MySQL
## testdb3 is ODBC/Connector 3.51.x, testdb5 is 5.1.x
channel <- odbcConnect("MysqlODBC")  #my database
odbcGetInfo(channel)
sqlTypeInfo(channel)
sqlTables(channel)


sqlDrop(channel, "test.USArrests",errors = FALSE)  #explicit database AND table call as MySQL doesn't allow general table creation 

Everything works as advertised.
-----------------------------------------------------------------------------------------------

#Then we get here.  I have the USArrests data and checked it but tried to save as it produced an error.

sqlSave(channel, USArrests,"test.USArrests",rownames = "state", addPK = TRUE)

"Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test,  : 
  no parameters, so nothing to update"

The database table exists and upon edit of the table fields, all table info created correctly.

Attempted again adding "verbose=TRUE":
> sqlSave(channel, USArrests,"test.USArrests",rownames = "state", addPK = TRUE, verbose=TRUE)
Query: CREATE TABLE test.usarrests  (`state` varchar(255) NOT NULL PRIMARY KEY, `murder` double, `assault` integer, `urbanpop` integer, `rape` double)
Query: INSERT INTO test.usarrests ( `` ) VALUES ( ?,?,?,?,? )
Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test,  : 
  no parameters, so nothing to update

Does anyone know what is happening? For whatever reason it is not "seeing" or ingesting the data (BOLDED "Query:..".


I've seen one other post that did not receive an answer (probably due to its lack of brevity).


I'm using Window's Vista, R 2.11.1


Here's is my MySQL info:

> odbcGetInfo(channel)
             DBMS_Name               DBMS_Ver        Driver_ODBC_Ver       Data_Source_Name            Driver_Name             Driver_Ver 
               "MySQL"     "5.1.33-community"                "03.51"            "MysqlODBC"          "myodbc5.dll"           "05.01.0007" 
              ODBC_Ver            Server_Name 
          "03.52.0000" "localhost via TCP/IP" 



Thank you for your time.

Mark LoPresti
	[[alternative HTML version deleted]]

