Re: [R] connecting to Oracle

2009-10-25 Thread whizvast
I found an old Internet posting and it solved my problem. For those who is suffering from the same problem, try this: channel <- odbcDriverConnect(connection="Driver={Microsoft ODBC for Oracle};DSN=abc;UID=abc;PWD=abc", case = 'oracle') x <- sqlQuery(channel, paste("select * from db_name.tbl_na

Re: [R] connecting to Oracle

2009-10-23 Thread Marc Schwartz
On Oct 23, 2009, at 2:08 PM, whizvast wrote: Hi, useR- I am connecting to Oracle database using RODBC, but keep getting this error message: library(RODBC) channel <- odbcConnect(dsn="abc", uid="abc", pwd="abc", case='oracle') Warning in odbcDriverConnect(st, ...) : [RODBC] ERROR: stat

[R] connecting to Oracle

2009-10-23 Thread whizvast
Hi, useR- I am connecting to Oracle database using RODBC, but keep getting this error message: > library(RODBC) > channel <- odbcConnect(dsn="abc", uid="abc", pwd="abc", case='oracle') Warning in odbcDriverConnect(st, ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver M