Re: [R] RODBC in R

From: Marc Schwartz <>
Date: Thu, 17 Jun 2010 08:44:07 -0500

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:

HTH, Marc Schwartz mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Thu 17 Jun 2010 - 13:55:36 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 17 Jun 2010 - 14:10:31 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive