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]