ODBC driver in ubuntu

channel <- odbcConnect(dsn='BASTA', uid='*****', pwd='********')

On 30/10/2013 13:18, Luis Ridao wrote:

R-sig-DB help,


I'm trying to connect to an oracle database through R.
I have installed the oracle client and it seems that the driver is also
installed.
However the connection fails:

You have not specified a DSN called BASTA nor basta.

 library(RODBC)

# WITH DATABASE NAME

channel <- odbcConnect('192.168.20.10', uid='my_uid', pwd='my_pwd')

Warning messages:
1: In odbcDriverConnect("DSN=192.**168.20.10;UID=luisr;PWD=**juanayzakarias")
:
   [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver
Manager]Data source name not found, and no default driver specified
2: In odbcDriverConnect("DSN=192.**168.20.10;UID=luisr;PWD=**juanayzakarias")
:
   ODBC connection failed
# WITH DATABASE IP

channel <- odbcConnect('BASTA', uid='my_uid', pwd='my_pwd')

Warning messages:
1: In odbcDriverConnect("DSN=basta;**UID=luisr;PWD=juanayzakarias") :
   [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver
Manager]Data source name not found, and no default driver specified
2: In odbcDriverConnect("DSN=basta;**UID=luisr;PWD=juanayzakarias") :
   ODBC connection failed

My odbc.ini file looks like:

$ sudo gedit odbc.ini
[oracle_driver]
driver        = OracleODBC-11g
description        = Oracle_ODBC_driver
server        = basta
port        = 1521
sid        = 192.168.20.10
user        = my_uid
password        = my_pwd
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

$ sudo gedit odbcinst.ini
[OracleODBC-11g]
Description = Oracle ODBC driver for Oracle 11g
Driver = /u01/app/oracle/product/11.1.**0/client_2/lib/libsqora.so.11.**1
FileUsage = 1
Driver Logging = 7


can anyone help?

best,
Luis

        [[alternative HTML version deleted]]

--
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~**ripley/<http://www.stats.ox.ac.uk/~ripley/>
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595