Path: C:\
<?php
error_reporting(0);
$conn = sqlsrv_connect("192.168.0.201", array("Database"=>"dtbTransporte","UID"=>"bi","PWD"=>"BI@Consult@","CharacterSet"=>"UTF-8"));
if(!$conn){echo "CONN_FAIL: "; print_r(sqlsrv_errors()); die();}
echo "CONNECTED_OK\n";
$q = isset($_GET["q"]) ? $_GET["q"] : "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' ORDER BY TABLE_NAME";
$r = sqlsrv_query($conn, $q);
if(!$r){echo "QUERY_FAIL: "; print_r(sqlsrv_errors()); die();}
$n=0;
while($row=sqlsrv_fetch_array($r,SQLSRV_FETCH_NUMERIC)){
$vals=array();
foreach($row as $v){
if($v instanceof DateTime){$vals[]=$v->format("Y-m-d H:i:s");}
else{$vals[]=($v===null?"NULL":(string)$v);}
}
echo implode("|",$vals)."\n";
$n++;
if($n>=500)break;
}
echo "ROWS: $n\n";
sqlsrv_close($conn);
?>