Rob,
First of all : turning the listener on requires only minimal resources.
Secondly: to make a local connection, you should leave the 'connectstring' empty in
the DBI connect call, but set your ORACLE_SID environment variable to point to the
database you want to connect to.
Best regards,
Mark
Rob Messer wrote:
> I've been using DBD::Oracle for a while on several Linux servers that have Oracle 8i
>installed on the same server. It works well, but there is a nagging problem -- I
>can't get the DBD to Oracle connection to work without turning the listener on. The
>database is on the same server as the perl code, so as I understand it I shouldn't
>need the Oracle listener on, and I'd much prefer to turn it off to save memory and
>prevent any external sources from trying to connect with the database.
>
> I've tried all the variations in the DBD::Oracle help file, but none of them seem to
>work. Can anyone point me to a good explanation of how this connection should work
>with the database on the same server as the DBD::Oracle code? Thanks,
>
> Rob
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
EMEA Support Information Systems Email : [EMAIL PROTECTED]
AIM : markvdb
