Hey Friends,

   I have two ORACLE_HOME directories in my client
machine (7.2.2 and 8.0.5). When I set ENV to 8.0.5 or
7.2.2, this seems there no effect. Also when I use the
connection like this :  

$dbh = DBI->connect("DBI:Oracle:$sid", "$username",
"$password",
{ RaiseError => 1, AutoCommit => 0 } );

I get ORA-12545 error.

But when I use this:
 $dbh = DBI->connect('dbi:Oracle:',
"$username/$password@(DESCRIPTION =
(ADDRESS=(PROTOCOL=TCP)(HOST=$server)(PORT=$port))
(CONNECT_DATA=(SID=$sid)))", "");

I get connected.

How to force the connection to use 8.0.5?

Thank you for your help in advance.

Ben



__________________________________________________
Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays!
http://calendar.yahoo.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to