[R-sig-DB] ORACLE driver Ubuntu

[Marc Schwartz]

Luis,

The service id setting that you have in odbc.ini seems a bit strange. Typically the sid does not contain the server's IP address, but a name that corresponds to the service name designated for the Oracle server and possibly associated with a particular database on the server. This is typically where the tnsnames.ora file comes into play in order to match up with the tns listener service configuration on the Oracle server. 

There is a need to have consistency in the names and configuration settings used across tnsnames.ora, odbcinst.ini and odbc.ini. 


There is a bunch of config information on the Oracle site here:

  http://download.oracle.com/docs/cd/B28359_01/gateways.111/b31042/configodbc.htm

that you might find helpful.


BTW, I believe that the Easysoft drivers are still purchased? Oracle does offer free ODBC drivers for 32 and 64 bit Linux:

  http://www.oracle.com/technology/software/tech/oci/instantclient/index.html


EasySoft also has a Getting Started Guide here:

  http://www.easysoft.com/products/data_access/odbc_oracle_driver/getting_started.html

and some additional technical content here:

  http://www.easysoft.com/support/kb/products/odbc_oracle_driver/index.html


You may need to contact the EasySoft folks for additional support, which you should be entitled to since you have presumably paid for their product.

HTH,

Marc Schwartz


On Mar 1, 2010, at 7:28 AM, Luis Ridao Cruz wrote:

> Hi,
> 
> I already asked for help regarding the following topic. 
> I have worked on it ever since but the problem is still unsolved.
> 
> I have installed an ODBC Driver for Linux (from the easySoft website)
> 
> I want to connect to our database through R via:
> 
> 
> 
> 
>> library(RODBC)
>> odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS")
> [1] -1
> Warning messages:
> 1: In odbcDriverConnect("SERVER=IP_address:1521;DRIVER=ORACLE;DATABASE=MAGNUS") :
>  [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified
> 2: In odbcDriverConnect("SERVER=IP_address:1521;DRIVER=ORACLE;DATABASE=MAGNUS") :
>  ODBC connection failed
> 
> I tried several other possibilities, e.g. 
> 
>> odbcDriverConnect("SERVER=oserver:PORT;DRIVER=ORACLE;DATABASE=IP_address/MAGNUS")
> 
> but all of them fail
> 
> Attached are my odbc.ini and odbcinst.ini files.
> Can anyone let me know how to fix this?
> 
> 
> ## file odbc.ini
> [ORACLE]
> driver		= Easysoft ODBC-Oracle WP
> description		= Easysoft Oracle ODBC WP driver
> server		= oserver
> port		= 1521
> sid		= xxx.xxx.xx.xxx/MAGNUS
> user		= luisr
> password		= myPassword
> logging		= No
> logfile		= 
> enable_user_catalog		= yes
> enable_synonyms		= yes
> metadata_dont_change_case		= no
> metadata_dont_do_schema		= no
> metadata_id		= no
> limit_long		= 0
> 
> ## file odbcinst.ini
> [Easysoft ODBC-Oracle WP]
> Description		= Easysoft Oracle ODBC WP Driver
> Driver		= /usr/local/easysoft/oraclewp/lib/libesorawp.so
> Setup		= /usr/local/easysoft/oraclewp/lib/libesorawpS.so
> Threading		= 0
> FileUsage		= 1
> DontDLClose		= 1
> UsageCount		= 1
> 
> 
> Running on Ubuntu 9.10 karmic
> 
> Thanks in advance