<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:13pt"><DIV>I get 42 when I run the code you provided, however, I still can't run my script. Any other thing I could test for? </DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>Grace<BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 13pt"><BR>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 13px"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">寄件人﹕</SPAN></B> Andy Yates <ayates@ebi.ac.uk><BR><B><SPAN style="FONT-WEIGHT: bold">收件人﹕</SPAN></B> Grace Cheng <himwo@yahoo.com.hk><BR><B><SPAN style="FONT-WEIGHT: bold">副本(CC)</SPAN></B> dev ensembl <dev@ensembl.org><BR><B><SPAN style="FONT-WEIGHT: bold">傳送日期﹕</SPAN></B> 2010/8/4 (三) 9:41:14 PM<BR><B><SPAN style="FONT-WEIGHT: bold">主題：</SPAN></B> Re: [ensembl-dev] Re： Can't connect to ensembl database<BR></FONT><BR>I would suggest prodding the DBI connection parameters in a separate call. The following will connect to EnsemblDB & will also raise an error if it cannot do the connection with some error information<BR><BR>use strict;<BR>use warnings;<BR>use DBI;<BR>my $host ='ensembldb.ensembl.org';<BR>my $port = 5306;<BR>my $user = 'anonymous';<BR>my $pass = undef;<BR>my $dbh = DBI->connect( "DBI:mysql:host=$host;port=$port", $user, $pass ) or die
$DBI::errstr; <BR>warn $dbh->selectrow_array('select 42');<BR>$dbh->disconnect();<BR><BR>If you get a warning saying 42 then this is fine; if not then post the DBI error back to the list.<BR><BR>Andy</DIV></DIV></div><br>
</body></html>