R help - Aug 2009 - RODBC: how to set the data-source?

Hello,

I want to try to connect R to PostgreSQL.

I have found that there are three ways:
DBI or RODBC or RPostgreSQL.

I tried around with DBI and RODBC but didn't get it running.

In both cases I'm not clear about how to set the driver/data source.


I get this error:


x  > channel <- odbcConnect("rtest", uid="oliver")
x  Warning messages:
x  1: In odbcDriverConnect(st, ...) :
x    [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data
x  source name not found, and no default driver specified
x  2: In odbcDriverConnect(st, ...) : ODBC connection failed
x  > 


So I somehow have to set the Driver.
But how?
I didn't find it out.


Ciao,
   Oliver

Oliver Bandel <oliver <at> first.in-berlin.de>
writes:
> odbcDataSources()
named character(0)
> 

This looks like nothing is available via RODBC interface.

Any idea what's missing?

How can I get all names of available drivers?

Ciao,
  Oliver

Looks like Unix....

If so, make sure your script has the proper paths set

Here is my set up for an oracle DB

export LD_LIBRARY_PATH=/../../instantclient_11_1:/../../unixODBC64_1/lib
export ODBCINI=/../..//unixODBC64_1
export ODBCSYSINI=/../..//unixODBC64_1 

And of course you need your db defined in ODBC.ini and this will link to
your driver code...

hth

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org]
On Behalf Of Oliver Bandel
Sent: Friday, August 28, 2009 10:22 AM
To: r-help at stat.math.ethz.ch
Subject: [R] RODBC: how to set the data-source?

Hello,

I want to try to connect R to PostgreSQL.

I have found that there are three ways:
DBI or RODBC or RPostgreSQL.

I tried around with DBI and RODBC but didn't get it running.

In both cases I'm not clear about how to set the driver/data source.


I get this error:


x  > channel <- odbcConnect("rtest", uid="oliver") x 
Warning messages:
x  1: In odbcDriverConnect(st, ...) :
x    [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver
Manager]Data
x  source name not found, and no default driver specified x  2: In
odbcDriverConnect(st, ...) : ODBC connection failed x  > 


So I somehow have to set the Driver.
But how?
I didn't find it out.


Ciao,
   Oliver

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

=============================================================================== 
 Please access the attached hyperlink for an important electronic communications
disclaimer:
 http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html