ORACLE driver Ubuntu
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