public static function runQueryWithLinkedServers($query)
{
try {
$mssql = ExternalMSSQL::GetConnectionFromCreds(ExternalMSSQL::getTychoCredentials());
} catch (PDOException $e) {
echo $e->getMessage();
echo "connect problem";
exit;
}
try {
$mssql->setAttribute(pdo::ATTR_ERRMODE, pdo::ERRMODE_EXCEPTION);
$stmt = $mssql->prepare($query);
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute();
$arrValues = $stmt->fetchAll();
} catch (PDOException $e) {
echo $e->getMessage();
exit;
}
//TODO: get rid of rnum column
foreach ($arrValues as $row) {
$result[] = $row;
}
return $result;
}