Displaying 1 result from an estimated 1 matches for "watervogellocaties_copy".
2012 Nov 26
2
puzzling RODBC error
...n about the channel and lists all tables in the database. If I try sqlFetch(), then R crashes.
I'm happy to hear suggestions on how to solve this.
Best regards,
Thierry
> MDB <- odbcConnectAccess("//inbodata/indata/Projects/PRJ_Watervogels/Geoloket/Telgebieden watervogeltellingen/Watervogellocaties_copy.mdb")
> sqlQuery(channnel = MDB, "SELECT gebiedscode FROM ganzengebieden;")
Error in sqlQuery(channnel = MDB, "SELECT gebiedscode FROM ganzengebieden;") :
first argument is not an open RODBC channel
> sqlTables(channel = MDB) #truncated output!
TABLE_SCHEM...