Re: [R] RODBC: how to set the data-source?

2009-08-29 Thread Oliver Bandel
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)

Re: [R] RODBC: how to set the data-source?

2009-08-29 Thread Oliver Bandel
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

[R] RODBC: how to set the data-source?

2009-08-28 Thread Oliver Bandel
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 -

Re: [R] RODBC: how to set the data-source?

2009-08-28 Thread Oliver Bandel
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 __

Re: [R] RODBC: how to set the data-source?

2009-08-28 Thread Dumblauskas, Jerry
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

Re: [R] RODBC: how to set the data-source?

2009-08-28 Thread Oliver Bandel
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

Re: [R] RODBC: how to set the data-source?

2009-08-28 Thread Dumblauskas, Jerry
/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

Re: [R] RODBC: how to set the data-source?

2009-08-28 Thread Oliver Bandel
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=

Re: [R] RODBC: how to set the data-source?

2009-08-28 Thread Oliver Bandel
... 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

Re: [R] RODBC: how to set the data-source?

2009-08-28 Thread Dumblauskas, Jerry
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

Re: [R] RODBC: how to set the data-source?

2009-08-28 Thread Oliver Bandel
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