Hello Michael,
>The method you have been using for passing the instance to connect() has
>been deprecated for several years now. I've always used
>...connect("dbi:Oracle:$sid", $uid, $pwd), does that work for you?
I guessed as much, just wanted a confirmation. Actually
the method you put in your mail doesn't work either, I get
the same TNS error - the only thing that gets a connection
to the local database now is to code the data source as
"dbi:Oracle:".
$ORACLE_SID still seems to be used to determine which local
instance to connect to though.
Anyway, now I know the answer - thanks,
Steve