I'm having a small problem using RODBC. I'm trying to retrieve a string
from a very long memo field (512*20*9=9360 characters = 74880 bytes) in
an MSAccess database.
It appears that RODBC set a maximum buffer size for a single column of
65535 bytes.
########## cut from RODBC.c ##########
} else { /* transfer as character */
int datalen = thisHandle->ColData[i].ColSize;
if (datalen <= 0 || datalen < COLMAX) datalen = COLMAX;
/* sanity check as the reports are sometimes unreliable */
if (datalen > 65535) datalen = 65535;
######################################
Can I increase this by just changeing the value in RODBC.c? If so how do
I get R to re-compile the package?
Thanks for your advice
Tom
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
