[R] dsn

[Uwe Ligges]

Margarida =?iso-8859-1?Q?Júlia?= Rodrigues Igreja wrote:

> Hi,
> 
> I've finally got a DSN working on my ODBC installation 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:
> 
>  > 
> odbcConnect("H:\\Desktop\\bd1",uid="tiago",pwd="archi",case="nochange",believeNRows=TRUE) 

If you have specified the DSN "bd1" using Windows' Control Panel, you 
don't need to specify any path - just specify the DSN itself, as in:

 
odbcConnect("bd1",uid="tiago",pwd="archi",case="nochange",believeNRows=TRUE) 



Uwe Ligges


> [1] -1
> 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
> What am I missing?
> 
> Margarida
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! 
> http://www.R-project.org/posting-guide.html