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? > > Thanks
You 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 ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.