[R] RODBC in R

[Marc Schwartz]

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