Dumblauskas, Jerry jerry.dumblauskas at credit-suisse.com writes:
OK
Is your PostGres server on the same Linux box you are running R on?
Sample values
Server = 169.49.30.69 (localhost host means you are on the same
box)
Port= 2700 (make sure your port is correct)
Dumblauskas, Jerry jerry.dumblauskas at credit-suisse.com writes:
[...]
The alloc error means you are close...
[...]
Ah, ok, I see...
...then you are right that Driver has to be the path to
the shared library. :-)
Oliver
__
R-help@r-project.org
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 -
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
__
defined in ODBC.ini and this will link to
your driver code...
hth
-Original Message-
From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org]
On Behalf Of Oliver Bandel
Sent: Friday, August 28, 2009 10:22 AM
To: r-h...@stat.math.ethz.ch
Subject: [R] RODBC: how to set the data
Dumblauskas, Jerry jerry.dumblauskas at credit-suisse.com writes:
Looks like Unix
...well, near by: Linux.
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
/instantclient_11_1/libsqora.so.11.1
Send over your odbc.ini entry
-Original Message-
From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org]
On Behalf Of Oliver Bandel
Sent: Friday, August 28, 2009 1:22 PM
To: r-h...@stat.math.ethz.ch
Subject: Re: [R] RODBC: how to set
Hi,
in
/usr/share/doc/r-cran-rodbc/README.gz
I found this example:
==
[testpg]
Description = testpg
Driver = PostgreSQL
Trace = No
TraceFile =
ServerName = localhost
UserName= ripley
Port= 5432
Socket =
Database=
... I also tried this one:
r...@siouxsie:~# odbcinst -q -d
odbcinst: SQLGetPrivateProfileString failed with .
r...@siouxsie:~#
failed with . ... what a verbose and detailed error message :-(
Oliver
__
R-help@r-project.org mailing list
Message-
From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org]
On Behalf Of Oliver Bandel
Sent: Friday, August 28, 2009 2:22 PM
To: r-h...@stat.math.ethz.ch
Subject: Re: [R] RODBC: how to set the data-source?
Hi,
in
/usr/share/doc/r-cran-rodbc/README.gz
I found this example
Dumblauskas, Jerry jerry.dumblauskas at credit-suisse.com writes:
OK
Is your PostGres server on the same Linux box you are running R on?
Sample values
Server = 169.49.30.69 (localhost host means you are on the same
box)
yes, all is local here.
Port= 2700 (make
11 matches
Mail list logo