[R] RODBC Access/Excel driver location for 64 bit Win7

2010-09-16 Thread Peter Holck
Apologies, but after a fair amount of digging, I still only have a foggy understanding of the cause of this problem, due to my own ignorance. I hope to use RODBC package to connect to an Access DB when running 64 bit Win7 (R version 2.11.1, 64 bit). I have successfully done this before on a winXP

[R] survey package: proportion estimate confidence intervals using svymean

2008-02-13 Thread Peter Holck
perhaps use the machinery of the survey package svyglm function with logit link (family=quasibinomial) to do the calculations for me. Still, seems rather cumbersome. Is there a better solution? Thanks for any suggestions or pointing out the errors in my logic! Peter Holck

[R] setSqlTypeInfo function in RODBC package

2007-10-18 Thread Peter Holck
I'm a little confused about what I'm doing wrong using the setSqlTypeInfo function to modify character size output: > setSqlTypeInfo("MySQL", + list(double="double", + integer="integer", + character="varchar(30)", + logical=