Andrey
the ora-12222 error normally occurs when there is a syntax error in your
connect string. Try using the alias in your tnsnames.ora file instead
my $dbh = DBI->connect("dbi:Oracle:$db_sid", $db_user, $dp_pass)
where $db_sid is the alias name. When you mentioned that SQL*plus can
connect, did you mean using user/pass or user/pass@sid?
Dan
-----Original Message-----
From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 11, 2001 2:49 AM
To: '[EMAIL PROTECTED]'
Subject: ORA-12222: TNS:no such protocol adapter
<< File: ATT00001.txt; charset = windows-1255 >>