[R] Error while connecting to Oracle using RODBC package

[Marc Schwartz]

On Jul 13, 2010, at 11:57 PM, vikrant wrote:

> 
> Dear All,
> I want to connnect R with oracle. I am using RODBC package for this
> connection. Following is my code to connect 
> 
> library(RODBC)
> channel <- odbcConnect("Vikrant")
> 
> I am getting following error.
> 1: In odbcDriverConnect("DSN=Vikrant") :
>  [RODBC] ERROR: state NA000, code 12288, message [Microsoft][ODBC driver
> for Oracle][Oracle]ORA-12514: TNS:listener does not currently know of
> service requested in connect descriptor
> 2: In odbcDriverConnect("DSN=Vikrant") :
>  [RODBC] ERROR: state 01000, code 0, message [Microsoft][ODBC Driver
> Manager] The driver doesn't support the version of ODBC behavior that the
> application requested (see SQLSetEnvAttr).
> 3: In odbcDriverConnect("DSN=Vikrant") : ODBC connection failed
> 
> I also tried by using another command
> 
> 
> library(RODBC)
> connection = odbcDriverConnect("driver=ORACLE
> Server;server=01hw0038336";DSN=vikrant;UID=system;PWD=password)
> 
> Then I am getting folllowing error.
> 1: In odbcDriverConnect("driver=ORACLE Server;server=01hw088089") :
>  [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
> Manager] Data source name not found and no default driver specified
> 2: In odbcDriverConnect("driver=ORACLE Server;server=01hw088089") :
>  ODBC connection failed
> 
> 
> Any help would be greatly appreciated..


What OS are you on? Presumably Windows.

Have you correctly configured the System or User DSN for the Oracle connection? The error messages suggest perhaps not. Verify the DSN connection information with your Oracle Admin.

See:

  vignette("RODBC") 

for more information.

Are you by chance on a 64 bit Windows platform, running 32 bit R? If so, be sure that your ODBC driver for Oracle is 32 bit and not 64 bit, which could also result in a conflict.

HTH,

Marc Schwartz