Using...
$dbh = DBI->connect('dbi:Oracle:TEST1', 'test1', 'test1' , {Printerror => 0,
RaiseError => 1} );
I get Oracle error ORA-12154 TNS: could not resolve service name (DBD Error:
OCIServerAttach)
Yet I don't really want to use TNS (I think) - I want to do an old fashioned
connect to SID TEST1 using userid/passwd test1/test1 equivalent to
ORACLE_HOME=/opt/oracle.....
ORACLE_SID=TEST1
sqlplus test1/test1
Can someone explain what is going on? I'm quite happy to admit I might have
a configuration error either in the DBD installation or in Oracle but what
do I do about it?
How does DBI differentiate between the types of (Oracle) connect string it
can receive anyway? This is one area where I feel the O'Reilly "Programming
the perl DBI" is a bit short on explained examples :-}
(I'm not a real Oracle DBA, so I'm quite happy to confess to being stupid
;-D )
Many thanks
Bill