[R] ODBC access

gfaieta@katamail.com gfaieta at katamail.com
Mon Aug 25 20:02:24 CEST 2003

Hello everybody,
I have tried to connect to external databases (specifically, to a MS Access database in my computer) from R using the RODBC package. Unfortunatelly I haven't been able to do it, even if I 'followed' the instructions in the manual. COuld someone please help me?

I have a MS Access database in my computer and I went to the control panel in order to create a DSN file linked to that database. When I'm in R I tried to coneect to it using the command 
but it doesn't work. I received these messages:
Warning messages: 
1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 
2: ODBC connection failed in: odbcDriverConnect(paste("DSN=", dsn, ";UID=", uid, ";PWD=", pwd,  

Thanks for your coperation.
Giuseppe Faieta

More information about the R-help mailing list