String always null through ODBC php client

1

I have a simple table with two columns an Id and a varchar for description.
A simple select always get Null values for the second column.
In Dremio UI it is correct.
In Excell it is correct.
In php, the column is always NULL. (I test with the linux ODBC 64 bit on Linux or With the Dremio Connector on Windows 10.
The php code is very simple :
echo 'Driver PDO Disponibles :
';
print_r(PDO::getAvailableDrivers());

try
{
echo ‘
Connexion sur la plateforme dremio.
’;
// On Linux $pdo2 = new PDO(“odbc:Driver={Dremio ODBC Driver 64-bit};Server=myipishidden;Port=31010;Database=DREMIO; Uid=lmenard;Pwd=xx;”);
$pdo2 = new PDO(“odbc:Driver={Dremio Connector};DBQ=Dremio Connector;Server=myipishidden;Port=31010;Database=DREMIO; Uid=lmenard;Pwd=xx;”);
// $pdo2->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
// $pdo2->setAttribute(PDO::ATTR_ORACLE_NULLS,PDO::NULL_NATURAL);
}
catch (PDOException $e)
{
echo 'Echec de la connexion adremio : ’ . $e->getMessage();
exit;
}

$sql_cdr = “SELECT IdCampaigns,CampaignsDesc FROM Backoffice2.campaigns”;
echo ‘Requete sql : ‘.$sql_cdr.’
’;
try {
$reqcdr = $pdo2->query($sql_cdr);
while($rowcdr = $reqcdr->fetch(PDO::FETCH_NUM))
{
var_dump($rowcdr);
echo “
”;
$WEMAInjectorCode=$rowcdr[0];
$acompter=1;
}
}
catch (PDOException $e)
{
echo 'Echec de la commande sql : '.$sql_cdr. $e->getMessage();
exit;
}
$reqcdr->closeCursor();
echo ‘Syncho finished’;

Here is the result (Second colum null !!!)
Driver PDO Disponibles :
Array ( [0] => mysql [1] => odbc [2] => sqlite )
Connexion sur la plateforme dremio.
Requete sql : SELECT IdCampaigns,CampaignsDesc FROM Backoffice2.campaigns
array(2) { [0]=> string(1) “7” [1]=> NULL }
array(2) { [0]=> string(2) “11” [1]=> NULL }
array(2) { [0]=> string(2) “13” [1]=> NULL }
array(2) { [0]=> string(2) “14” [1]=> NULL }
array(2) { [0]=> string(2) “18” [1]=> NULL }
array(2) { [0]=> string(2) “19” [1]=> NULL }
array(2) { [0]=> string(2) “20” [1]=> NULL }
array(2) { [0]=> string(2) “21” [1]=> NULL }
array(2) { [0]=> string(2) “24” [1]=> NULL }
array(2) { [0]=> string(2) “25” [1]=> NULL }
array(2) { [0]=> string(2) “27” [1]=> NULL }
array(2) { [0]=> string(2) “28” [1]=> NULL }
array(2) { [0]=> string(2) “29” [1]=> NULL }
array(2) { [0]=> string(2) “30” [1]=> NULL }
array(2) { [0]=> string(2) “31” [1]=> NULL }
array(2) { [0]=> string(2) “34” [1]=> NULL }
array(2) { [0]=> string(2) “35” [1]=> NULL }
array(2) { [0]=> string(2) “36” [1]=> NULL }
array(2) { [0]=> string(2) “37” [1]=> NULL }
array(2) { [0]=> string(2) “38” [1]=> NULL }
array(2) { [0]=> string(2) “39” [1]=> NULL }
array(2) { [0]=> string(2) “40” [1]=> NULL }
array(2) { [0]=> string(2) “42” [1]=> NULL }
array(2) { [0]=> string(2) “43” [1]=> NULL }
array(2) { [0]=> string(2) “44” [1]=> NULL }
array(2) { [0]=> string(2) “45” [1]=> NULL }
Syncho finished

Have you any idea ?

2

I solve my problem without using PDO_odbc but native odbc commands (odbc_connect, odbc_exec, odbc_fetch_array).
Strings are now the true values and not NULLL value with this code :
// Connexion ODBC native
try
{
echo ‘
Connexion NATIVE odnc_connect sur la plateforme dremio. Need to add in you php.ini :extension=php_odbc.dll
’;
$connection = odbc_connect(“Driver={Dremio Connector};DBQ=Dremio Connector;Server=mywindowsserver;Port=31010;Database=DREMIO; Uid=lmenard;Pwd=xx;”,“lmenard”,“xx”);
}
catch (Exception $e)
{
echo 'Echec de la connexion adremio : ’ . $e->getMessage();
exit;
}

$sql_cdr ="SELECT IdCampaignsCSRotation,mobilephone1,IdMOscriptsdetails,StartDate,EndDate,annee,mois,jour,heure,listen,id,NetworkOC_IdNetworkOC,IdCampaigns, ";
$sql_cdr = $sql_cdr.‘mediaobjects_IdMediaObjects,DurationMin,comptage,advertisers_idAdvertisers FROM “Mon espace”.struct_cdr_full’;
echo ‘Requete sql : ‘.$sql_cdr.’
’;
try {
$result=odbc_exec($connection,$sql_cdr);
while($rowcdr=odbc_fetch_array($result))
{
var_dump($rowcdr);
echo “
”;
}
}
catch (Exception $e)
{
echo 'Echec de la commande sql : '.$sql_cdr. $e->getMessage();
exit;
}