connecting oracle 9i

[rk68]

I'm getting an error while connecting to oracle using the following code:
$sDataBaseHandler = DBI->connect ( "DBI:Oracle:host=lyris; sid=dems; port=22", 'demsuser', 'demsuser' ) ;

the error is: DBI connect failed.

is there any error in the above code as the database name, sid, password & userid is correct.

TIA
Raj

 

[icrf]

does $DBI::errstr give you any more details? connect syntax looks alright according to the pod

________________________________________
Andrew

I work for a gift card company!