dsn
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