Skip to content

ORACLE driver Ubuntu

4 messages · Luis Ridao Cruz, Andrew Piskorski, Marc Schwartz

Original
Luis Ridao Cruz
# 
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:
[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.
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
1 day later
Andrew Piskorski
#
On Mon, Mar 01, 2010 at 01:28:16PM +0000, Luis Ridao Cruz wrote:

            

      
      
      
    

        
Is there any particular reason you want to use ODBC to talk to Oracle?
Have you verified that you can connect to Oracle via other means,
e.g., does sqlplus work?  You've installed the Oracle client libraries
on your Linux box, right?

I've never tried ODBC with Oracle so I can't help you there, but in my
experience ROracle mostly works for basic use, and Oratcl works very well.

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      Luis Ridao Cruz
    

    

      
      #
    

  


  

      
sqlplus works fine and I encountered  problems with ROracle
so I did not want to deep further.

Best,
Luis

            

      
      
      
    

        
On Mon, Mar 01, 2010 at 01:28:16PM +0000, Luis Ridao Cruz wrote:

        

            

      
      
      
    

        
Is there any particular reason you want to use ODBC to talk to Oracle?
Have you verified that you can connect to Oracle via other means,
e.g., does sqlplus work?  You've installed the Oracle client libraries
on your Linux box, right?

I've never tried ODBC with Oracle so I can't help you there, but in my
experience ROracle mostly works for basic use, and Oratcl works very well.

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      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: