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; }