[R-sig-DB] Can't connect to postgresql with RODBC.

[Geotronix]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

I've finally got a DSN working on my ODBC installation (via a
~/.odbc.ini file) and I've tested it with the ODBC DataManager so I'm
sure it's working.
However when trying to connect to the DSN via R interface I get an
error:

> channel <- odbcConnect("test", uid="ant", pwd="fr",
> case="postgresql")
Warning messages: 
1: [RODBC] ERROR: state IM002, code 0, message [unixODBC][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,  
> 

Before the odbcCOnnect() command I gave the library(RODBC) command and
it gave no error (I installed r-cran-rodbc on my woody).

I'm using the PDF file "R data import/Export" as a guide and it doesn't
recall any configuration for RODBC. What am I missing?

If unixODBC finds my DSN why isn't RODBC finding it? (This means it's
not a unixODBC problem, right?)

Bye
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/ojsKIRaQQEznKxURAqWTAJ9CQ6BR/1L38CeB3OdhlgJaT/VJ6ACdHs3T
iyPa4GJxUz7UhPkeBAzITFo=
=ARSM
-----END PGP SIGNATURE-----