I'm trying to get to grips with accessing my postgresql tables in R using RODBC. I have Mac OS 10.2.8 (Darwin 6.8) installed and R 1.8.0 installed from source and I have updated RODBC to 1.0-4.
On the ODBC manager end, I am using OpenLink software's iODBC Administrator and I've set up a User DSN called "PostGRES" - odbctest suggests that this is functioning:
[doibook:~] dorme% /usr/bin/odbctest iODBC Demonstration program This program shows an interactive SQL processor
Enter ODBC connect string (? shows list): dsn=PostGRES
Have a nice day. [doibook:~] dorme%
However, when I try to access the connection from R I get the following:
> test <- odbcConnect(dsn="PostGRES", uid="dorme", pwd="secret", case="postgresql")
Warning messages:
1: [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data so
urce name not found, and no default driver specified
2: ODBC connection failed in: odbcDriverConnect(paste("DSN=", dsn, ";UID=", uid,
";PWD=", pwd,
Any suggestions? My suspicion is that RODBC requires unixODBC and doesn't know about iOBDC, but in which case I wouldn't expect to see a Driver Manager error code.
Thanks, David
--------------------------------------- Dr. David Orme
Department of Biological Sciences Imperial College London Silwood Park Campus Ascot, Berkshire SL5 7PY UK.
Tel: +44 (0)20 759 42358 Fax: +44 (0)20 759 42339 e-mail: [EMAIL PROTECTED]
______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
