Re: PERL DBI connection to Remote Oracle Database

On 8/29/07, Yechiel Adar <adar666_at_inter.net.il> wrote:
>
> Jared, Ron and Cary
>
> As Sanjay wrote using Perl connecting with host=;sid= does not use
> tnsnames.
> The same as working with thin jdbc.
>
>

True, but DBI cannot connect to Oracle without the Oracle client.

The OP wanted to know how the connection was being made in the absence of a specific port #, hence my suggestion for enabling sqlnet tracing.

At this point I would suggest that Sanjay join the DBI users mail list.

http://lists.cpan.org/showlist.cgi?name=dbi-users

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l