$name,'UID'=>$user,'PWD'=>$pswd); $link=sqlsrv_connect($host,$connectionInfo); if(!is_resource($link)){ echo 'Unable to connect to database'; die( print_r( sqlsrv_errors(), true)); }else{ //Query the db $result = sqlsrv_query($link,"SELECT * FROM customers WHERE ".$filter, $params); if( $result === false){ echo "Error in query preparation/execution.\n"; die( print_r( sqlsrv_errors(), true)); } } /***** OUTPUT LIVE LOOKUP XML *****/ header('Content-type: text/xml'); echo ''; ?>