$Conn = $Server->CreateObject("ADODB.Connection");
$Conn->Open( "Provider=SQLOLEDB;User ID=USER;Password=PASSWORD;Initial
+ Catalog=DB;Data Source=SERVER" );
$Conn->CommandTimeout = 120;
$timeout = $Conn->CommandTimeout;

$sql = "Select Col1,Col2 from Table1 ";
$RS = $Conn->Execute( $sql,CommandTimeout=120);
if($Conn->Errors->{Count} > 0) {
%> Error is <% =$Conn->Errors(0)%>


...