Re: [R] RODBC in R

As Marc already pointed out, you masked your pwd with , but you didn't correctly used the arguments. "your ODBC connection" is the name of your ODBC connection you setup in your environment. Like "postgresql35W" or something I can't write out a complete syntax when I don't know your actual O

Re: [R] RODBC in R

please explain more about "your ODBC connection" as in brackets in your statement. I just masked my password in case using **. Please write complete syntax. Thank you -- View this message in context: http://r.789695.n4.nabble.com/RODBC-in-R-tp2258510p2258814.html Sent from the R help ma

Re: [R] RODBC in R

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

Re: [R] RODBC in R

Hi, case should be tolower, toupper, nochange, not "*" . I think you switched case for pwd? Anyway, you can just use odbConnect("yourODBC connection") to connect to your ODBC db. Bart -- View this message in context: http://r.789695.n4.nabble.com/RODBC-in-R-tp2258510p2258742.html Sen

[R] RODBC in R

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 | tolo