各位好,请教一个问题。
> library("nutshell")
Loading required package: nutshell.bbdb
Loading required package: nutshell.audioscrobbler
> library(RODBC)
> bbdb <- odbcConnect("bbdb")
> odbcGetInfo(bbdb)
DBMS_Name
"SQLite"
DBMS_Ver
"3.7.15"
Driver_ODBC_Ver
"03.00"
Data_Source_Name
"bbdb"
Driver_Name
"sqlite3odbc.dll"
Driver_Ver
"0.99"
ODBC_Ver
"03.52.0000"
Server_Name
"C:\\Users\\abc\\Documents\\R\\win-library\\2.15\\nutshell.bbdb\\extdata\\bb.db"
> sqlTables(bbdb)
[1] TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE
[5] REMARKS
<0 rows> (or 0-length row.names)
sqlTables(bdb)命令的结果是上面给出的,为什么出现不了课本P163的结果?
前面已经按照他的1,2,3,4,5步做了,并且在Figure 11-7. SQLite3 ODBC configuration中的Database Name 填写的就是C:\\Users\\abc\\Documents\\R\\win-library\\2.15\\nutshell.bbdb\\extdata\\bb.db
其它的都和Figure 11-7完全一样。
如果再运行
> sqlColumns(bbdb,"Allstar")
得到的是
Error in sqlColumns(bbdb, "Allstar") :
‘Allstar’: table not found on channel
另外用命令
> .libPaths()
结果是
[1] "C:/Users/abc/Documents/R/win-library/2.15"
[2] "C:/Program Files/R/R-2.15.2/library"
[3] "C:/Program Files/RStudio/R/library"