Displaying 1 result from an estimated 1 matches for "prj_watervogels".
2012 Nov 26
2
puzzling RODBC error
...n using sqlQuery(). However, sqlTables() does not complain 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
>...