Beispiel #1
0
 /**
  * Retrieve server version in PHP style
  *
  * @return string
  */
 public function getServerVersion()
 {
     $this->_connect();
     $version = sqlsrv_client_info($this->_connection);
     if ($version !== false) {
         return $version['DriverVer'];
     }
     return null;
 }
Beispiel #2
0
 /**
  * Returns the libary version string.
  *
  * @return string
  */
 public function client_version()
 {
     $client_info = sqlsrv_client_info($this->conn);
     return $client_info['DriverODBCVer'] . ' ' . $client_info['DriverVer'];
 }
    /**
     * SQL Server check for client version
     *
     * @TODO Get this to actually check the client version.
     *
     * {@inheritDoc}
     */
    public function verifyClientVersion() {
        return array('result' => 'success', 'message' => $this->install->lexicon('sqlsrv_version_client_success',array('version' => '')));

        $clientInfo = @sqlsrv_client_info();
        $sqlsrvVersion = $clientInfo['DriverVer'];
        $sqlsrvVersion = $this->_sanitizeVersion($sqlsrvVersion);
        if (empty($sqlsrvVersion)) {
            return array('result' => 'warning','message' => $this->install->lexicon('sqlsrv_version_client_nf'),'version' => $sqlsrvVersion);
        }

        $sqlsrv_ver_comp = version_compare($sqlsrvVersion,'10.50.0','>=');
        if (!$sqlsrv_ver_comp) {
            return array('result' => 'warning','message' => $this->install->lexicon('sqlsrv_version_client_old',array('version' => $sqlsrvVersion)),'version' => $sqlsrvVersion);
        } else {
            return array('result' => 'success','message' => $this->install->lexicon('sqlsrv_version_success',array('version' => $sqlsrvVersion)),'version' => $sqlsrvVersion);
        }
    }
 /**
  * (non-PHPdoc)
  * @see DBManager::getDbInfo()
  * @return array
  */
 public function getDbInfo()
 {
     $info = array_merge(sqlsrv_client_info(), sqlsrv_server_info());
     return $info;
 }
 /**
  * Returns an associative array with keys described in the table below. Returns FALSE otherwise.
  * ==================================================
  *  Key				Description
  *  ==================================================
  *	DriverDllName	SQLNCLI10.DLL
  *	DriverODBCVer	ODBC version (xx.yy)
  *	DriverVer	SQL Server Native Client DLL version (10.5.xxx)
  *	ExtensionVer	php_sqlsrv.dll version (2.0.xxx.x)
  * @return multitype:
  */
 public function getClientInfo()
 {
     return sqlsrv_client_info($this->dbconnection);
 }
Beispiel #6
0
 /**
  * @depends testConnection
  */
 public function testClientInfo($con)
 {
     echo "\nClient Info function test.\n";
     // TODO: make better tests
     $client_info = sqlsrv_client_info($con);
     urp::info($client_info);
     $this->assertTrue(is_array($client_info));
 }
Beispiel #7
0
 /**
  * (non-PHPdoc)
  * @see DBManager::getDbInfo()
  * @return array
  */
 public function getDbInfo()
 {
     $info = array_merge(sqlsrv_client_info($this->database), sqlsrv_server_info($this->database));
     return $info;
 }
Beispiel #8
0
function cs_sql_version($cs_file)
{
    global $cs_db;
    $sql_infos = array('data_free' => 0, 'data_size' => 0, 'index_size' => 0, 'tables' => 0, 'names' => array());
    $client = sqlsrv_client_info($cs_db['con']);
    $server = sqlsrv_server_info($cs_db['con']);
    $sql_infos['encoding'] = 'default';
    $sql_infos['type'] = 'Microsoft SQL Server (sqlsrv)';
    $sql_infos['client'] = $client['DriverVer'] . ' - ODBC ' . $client['DriverODBCVer'];
    $sql_infos['host'] = $server['SQLServerName'];
    $sql_infos['server'] = $server['SQLServerVersion'];
    return $sql_infos;
}