Change your sqlnet.ora to read: Names.directory_path = (LDAP)
This assumes you have a proper ldap.ora file in the same location as your sqlnet.ora. -- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Alexander Foken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 1:55 PM To: Loo, Peter # PHX Cc: [email protected] Subject: Re: DBI->data_sources('Oracle') As far as I understand DBD::Oracle (the driver DBI uses for Oracle), it is "just" a translator for the Oracle Call Interface (OCI), and to my knowledge, OCI uses TNSNAMES.ORA. If you use a recent Oracle client software, the OCI may perhaps emulate a TNSNAMES.ORA based on the Oracle Internet Directory. *If* that works, it is documented (or should I say burried alive?) somewhere in the Oracle documentation. My guess is that you would add some special entry to TNSNAMES.ORA to make the OCI lookup databases in the Oracle Internet Directory. Alexander On 02.05.2006 21:09, Loo, Peter # PHX wrote: >Is there anyway that I can force Perl DBI to not use TNSNAMES.ORA and >instead use Oracle Internet Directory? > >-----Original Message----- >From: Alexander Foken [mailto:[EMAIL PROTECTED] >Sent: Tuesday, May 02, 2006 11:29 AM >To: Loo, Peter # PHX >Cc: [email protected] >Subject: Re: DBI->data_sources('Oracle') > >First guess: $ORACLE_HOME/NETWORK/ADMIN/TNSNAMES.ORA or >$ORACLE_HOME/NET80/ADMIN/TNSNAMES.ORA. > >Alexander >On 02.05.2006 20:15, Loo, Peter # PHX wrote: > > > >>Hi All, >> >>Will someone please tell me where this module is getting the >>information from? One of my severs that I am trying to connect to is >>NOT listed in the output of: >> >>@databases = $dbh->data_sources('Oracle'); >> >>Thanks. >> >>Peter >> >> >> >>This E-mail message is for the sole use of the intended recipient(s) >> >> >and may contain confidential and privileged information. Any >unauthorized review, use, disclosure or distribution is prohibited. If >you are not the intended recipient, please contact the sender by reply >E-mail, and destroy all copies of the original message. > > >> >> >> >> > > >-- >Alexander Foken >mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/ > > > >This E-mail message is for the sole use of the intended recipient(s) and >may contain confidential and privileged information. Any unauthorized >review, use, disclosure or distribution is prohibited. If you are not >the intended recipient, please contact the sender by reply E-mail, and >destroy all copies of the original message. > > >This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message. > > > -- Alexander Foken mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/ This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
