Re: [R-sig-DB] Using LDAP connection

2012-06-07 Thread Dirk Eddelbuettel

Scott,

Scott,

On 7 June 2012 at 09:40, Slawin, Scott wrote:
| Sean,
| 
| Thanks for quick reply!  The link you provide was exactly what I was looking 
for.  I now have it working without the use of TNSNAMES.ORA.
| Need to make sure that you are using the DB Service name in the ODBC 
configuration.

It would be useful for others if you could post a few bullet points as a
short HOWTO or recipe here...  ROracle comes up every now and then, and not
that many of us can help for lack of an Oracle system nearby.

Greetings from downtown to Northbrook,  Dirk

-- 
Dirk Eddelbuettel | e...@debian.org | http://dirk.eddelbuettel.com

___
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db


Re: [R-sig-DB] Using LDAP connection

2012-06-07 Thread Slawin, Scott
Sean,

Thanks for quick reply!  The link you provide was exactly what I was looking 
for.  I now have it working without the use of TNSNAMES.ORA.
Need to make sure that you are using the DB Service name in the ODBC 
configuration.

-- Scott 

-Original Message-
From: seand...@gmail.com [mailto:seand...@gmail.com] On Behalf Of Sean Davis
Sent: Thursday, June 07, 2012 9:00 AM
To: Slawin, Scott
Cc: r-sig-db@r-project.org
Subject: Re: [R-sig-DB] Using LDAP connection

On Thu, Jun 7, 2012 at 9:52 AM, Slawin, Scott  wrote:
> Hello,
>
> I am trying to find an R package that will allow me to connect to Oracle
> using LDAP.  Can someone help direct me to such a package or
> documentation.
>
> RCURL does mention LDAP, but is not very specific on how to use LDAP
> with sql statements.

Hi, Scott

I'd read up on ROracle or RODBC.  The LDAP piece is behind the Oracle
piece, I think, so you should not have to do anything special for
connecting.

I'm not sure how far this will get you, but you could take a look here
for one (of several) tutorials:

http://www.oracle.com/technetwork/articles/datawarehouse/saternos-r-161569.html

Sean
___
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db


Re: [R-sig-DB] Using LDAP connection

2012-06-07 Thread Sean Davis
On Thu, Jun 7, 2012 at 9:52 AM, Slawin, Scott  wrote:
> Hello,
>
> I am trying to find an R package that will allow me to connect to Oracle
> using LDAP.  Can someone help direct me to such a package or
> documentation.
>
> RCURL does mention LDAP, but is not very specific on how to use LDAP
> with sql statements.

Hi, Scott

I'd read up on ROracle or RODBC.  The LDAP piece is behind the Oracle
piece, I think, so you should not have to do anything special for
connecting.

I'm not sure how far this will get you, but you could take a look here
for one (of several) tutorials:

http://www.oracle.com/technetwork/articles/datawarehouse/saternos-r-161569.html

Sean

___
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db