When I am connecting to the server via ODBC I got the following error.>library(RODBC)channel <- odbcConnect("my server", uid="***" , case="*****") Error in switch(case, toupper = case <- 1L, tolower = case <- 2L, postgresql = case <- 2L, : Invalid case parameter: nochange | toupper | tolower | common db names How to fix this error? Thanks -- View this message in context: http://r.789695.n4.nabble.com/RODBC-in-R-tp2258510p2258510.html Sent from the R help mailing list archive at Nabble.com.
Hi,
case should be tolower, toupper, nochange,.... not "*****" .
I think you switched case for pwd?
Anyway, you can just use odbConnect("yourODBC connection") to connect
to
your ODBC db.
Bart
--
View this message in context:
http://r.789695.n4.nabble.com/RODBC-in-R-tp2258510p2258742.html
Sent from the R help mailing list archive at Nabble.com.
On Jun 17, 2010, at 4:48 AM, dhanush wrote:> > When I am connecting to the server via ODBC I got the following error. > >> library(RODBC) > channel <- odbcConnect("my server", uid="***" , case="*****") > > Error in switch(case, toupper = case <- 1L, tolower = case <- 2L, postgresql > = case <- 2L, : > Invalid case parameter: nochange | toupper | tolower | common db names > > How to fix this error? > > ThanksYou seem to think that the 'case' argument is for your password. The argument 'pwd' is for your password. Read ?odbcConnect for more information. Also, please note that there is a R SIG e-mail list for data base related queries: https://stat.ethz.ch/mailman/listinfo/r-sig-db HTH, Marc Schwartz
please explain more about "your ODBC connection" as in brackets in your statement. I just masked my password in case using ******. Please write complete syntax. Thank you -- View this message in context: http://r.789695.n4.nabble.com/RODBC-in-R-tp2258510p2258814.html Sent from the R help mailing list archive at Nabble.com.