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.

Reply via email to