I'm facing a problem right now, i explain :
I have my SQL query :
SELECT COUNT(*) AS nb, TO_CHAR(myDate,'yyyy-mm-dd') AS dateF, T1.IDCar, T2.IDMotor
FROM TDB2@MYLINKSERVER,T1
JOIN T2 ON T1.ID = T2.ID
WHERE TDB2.IDCar = T1.IDCar
Which use a TDB2@MYLINKSERVER , to connect 2 differents databases from Oracle and use a table from and other database.
In fact, when i launch the query in sql developper, my query returns some datas.
So in php, i have
$sql = $pdo->prepare('myquerybefore')
$sql->execute(array($annee));
$res = $sql->fetchAll(PDO::FETCH_ASSOC);
And when i try to vardump my $res, it returns array(0) { }
So i think that PDO don't use the @LINKSERVER to fetch results.
I have to say that my query works on SQL Developper, but didn't in PHP..
Any help would be appreciated
Thanks,