Problem
description:
When using RODBC 1.3-0 `sqlFetch' to
read an ESRI format personal geodatabase table containing binary shape
data, R crashes.
There is no crash under RODBC 1.2-6.
Code:
library(RODBC)
#
connect to
db
mdb
<-
odbcConnectAccess("r_test.mdb")
#
fetch the
table; this works under 1.2-6, fails under 1.3-0.
dat
<-
sqlFetch(mdb, "one_point")
Errors:
Sample
Data: r_test.mdb
The Access table has this format:
And looks like this in Access:
And in R (when RODBC works):
> dat
OBJECTID
Shape KC_food_sources_point_Unique_Identifier
1
1
010000008052E651575A334100963D8F4ACD0E41
PR0001403
ZCTA stfid_tract stfid_blkgrp
1
98103 5.3033e+10 5.3033e+11
**************************************************************
Phil Hurvitz, MFR | PhD Student, Urban Planning | CBE
1107 NE 45th Street, Suite 535 | Box 354802
University of Washington, Seattle, Washington 98195-4802, USA
phurvitz@u.washington.edu | http://gis.washington.edu/phurvitz
"What is essential is invisible to the eye." -de Saint-Exupéry
**************************************************************