Using DBD::Oracle with Net8 (for encryption)

[BigJoe]

I am using DBD::Oracle on my webservers to connect my perl scripts from the Apache server to the Oracle 8i databases. The documentation for DBD::Oracle says it uses sqlnet 1 and 2 and it bypasses the tnsnames.ora/sqlnet.ora. So how do I set it up to use net8 instead of sqlnet 1/2 to allow the DBA to encrypt the traffic? Thanks Joe

--BigJoe

Learn patience, you must.
Young PerlMonk, craves Not these things.
Use the source Luke.

[rdfield]

I believe that the documentation is out of date. Wherever it says SQL*Net 2.x read 'SQL*Net 2.x or later'. DBD::Oracle only bypasses the tnsnames.ora file if you supply a full connect descriptor, e.g. 'T:hostname:sid'. I use DBD::Oracle with a 9i setup and I can assure you that the connect arrives via SQL*Net after looking up the alias in tnsnames.ora and the values in sqlnet.ora. An easy way to check is to add the entry 'TRACE_LEVEL_CLIENT = ADMIN' to your local sqlnet.ora and look for .trc files in your current working directory. Remember to remove the entry before you do any serious processing otherwise it will use copious amounts of disk space.

rdfield