Re: [R] RODBC in R

From: Marc Schwartz <marc_schwartz_at_me.com>
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:

  https://stat.ethz.ch/mailman/listinfo/r-sig-db

HTH, Marc Schwartz



R-help_at_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. 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 https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive