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 >> 

Reply via email to