/** * Connects to a database. * @return void * @throws Dibi\Exception */ public function connect(array &$config) { Helpers::alias($config, 'options|UID', 'username'); Helpers::alias($config, 'options|PWD', 'password'); Helpers::alias($config, 'options|Database', 'database'); Helpers::alias($config, 'options|CharacterSet', 'charset'); if (isset($config['resource'])) { $this->connection = $config['resource']; } else { $options =& $config['options']; // Default values if (!isset($options['CharacterSet'])) { $options['CharacterSet'] = 'UTF-8'; } $options['PWD'] = (string) $options['PWD']; $options['UID'] = (string) $options['UID']; $options['Database'] = (string) $options['Database']; $this->connection = sqlsrv_connect($config['host'], $options); } if (!is_resource($this->connection)) { $info = sqlsrv_errors(); throw new Dibi\DriverException($info[0]['message'], $info[0]['code']); } $this->version = sqlsrv_server_info($this->connection)['SQLServerVersion']; }
public function server_version() { if ($this->lnk) { $info = sqlsrv_server_info($this->lnk); return $info['SQLServerVersion']; } return false; }
/** * {@inheritDoc} */ function sql_server_info($raw = false, $use_cache = true) { global $cache; if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mssql_version')) === false) { $arr_server_info = sqlsrv_server_info($this->db_connect_id); $this->sql_server_version = $arr_server_info['SQLServerVersion']; if (!empty($cache) && $use_cache) { $cache->put('mssql_version', $this->sql_server_version); } } if ($raw) { return $this->sql_server_version; } return $this->sql_server_version ? 'MSSQL<br />' . $this->sql_server_version : 'MSSQL'; }
/** * DB Connect * this method is private * @param array $connection connection's value is db_hostname, db_database, db_userid, db_password * @return resource */ function __connect($connection) { //sqlsrv_configure( 'WarningsReturnAsErrors', 0 ); //sqlsrv_configure( 'LogSeverity', SQLSRV_LOG_SEVERITY_ALL ); //sqlsrv_configure( 'LogSubsystems', SQLSRV_LOG_SYSTEM_ALL ); $result = @sqlsrv_connect($connection['host'], array('Database' => $connection['database'], 'UID' => $connection['user'], 'PWD' => $connection['pass'])); if (!$result) { $errors = print_r(sqlsrv_errors(), true); $this->setError(-1, 'database connect fail' . PHP_EOL . $errors); return; } $server_info = sqlsrv_server_info($result); $server_version = $server_info['SQLServerVersion']; if ($server_version && version_compare($server_version, '10', '<')) { $this->setError(-1, 'Rhymix requires Microsoft SQL Server 2008 or later. Current version is ' . $server_version); return; } return $result; }
/** * Returns database server info array * @return array Array containing 'description', 'version' and 'database' (current db) info */ public function get_server_info() { static $info; if (!$info) { $server_info = sqlsrv_server_info($this->sqlsrv); if ($server_info) { $info['description'] = $server_info['SQLServerName']; $info['version'] = $server_info['SQLServerVersion']; $info['database'] = $server_info['CurrentDatabase']; } } return $info; }
/** * @return string Version information from the database */ public function getServerVersion() { $server_info = sqlsrv_server_info($this->mConn); $version = 'Error'; if (isset($server_info['SQLServerVersion'])) { $version = $server_info['SQLServerVersion']; } return $version; }
/** * Database version number * * @return string */ public function version() { if (isset($this->data_cache['version'])) { return $this->data_cache['version']; } elseif (!$this->conn_id) { $this->initialize(); } if (!$this->conn_id or ($info = sqlsrv_server_info($this->conn_id)) === FALSE) { return FALSE; } return $this->data_cache['version'] = $info['SQLServerVersion']; }
public function getVersion() { return sqlsrv_server_info($this->_connected); }
/** * Retrieve server version in PHP style * * @return string */ public function getServerVersion() { $this->_connect(); $serverInfo = sqlsrv_server_info($this->_connection); if ($serverInfo !== false) { return $serverInfo['SQLServerVersion']; } return null; }
/** * return version information about the server * * @param bool $native determines if the raw version string should be returned * @return mixed array/string with version information or MDB2 error object * @access public */ function getServerVersion($native = false) { if ($this->connected_server_info) { $server_info = $this->connected_server_info; } else { $this->connect(); $server_info = sqlsrv_server_info($this->connection); } // cache server_info $this->connected_server_info = $server_info; $version = $server_info['SQLServerVersion']; if (!$native) { if (preg_match('/(\\d+)\\.(\\d+)\\.(\\d+)/', $version, $tmp)) { $version = array('major' => $tmp[1], 'minor' => $tmp[2], 'patch' => $tmp[3], 'extra' => null, 'native' => $version); } else { $version = array('major' => null, 'minor' => null, 'patch' => null, 'extra' => null, 'native' => $version); } } return $version; }
/** * Version number query string * * @access public * @return string */ function _version() { $info = sqlsrv_server_info($this->conn_id); return sprintf("select '%s' as ver", $info['SQLServerVersion']); }
/** * @depends testConnection */ public function testServer($con) { echo "\nServer info test."; // TODO: make better tests $this->assertTrue(is_array(sqlsrv_server_info($con))); }
/** * (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; }
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; }
/** * Return the database version. * * @return string */ public function version() { $server = sqlsrv_server_info($this->connection); return $server['SQLServerName'] . ': ' . $server['SQLServerVersion']; }
/** * SQL Server check for server version * * @TODO Get this to actually check the server version. * * {@inheritDoc} */ public function verifyServerVersion() { return array('result' => 'success','message' => $this->install->lexicon('sqlsrv_version_success',array('version' => ''))); $handler = @sqlsrv_connect($this->install->settings->get('database_server'),$this->install->settings->get('database_user'),$this->install->settings->get('database_password')); $serverInfo = @sqlsrv_server_info($handler); $sqlsrvVersion = $serverInfo['SQLServerVersion']; $sqlsrvVersion = $this->_sanitizeVersion($sqlsrvVersion); if (empty($sqlsrvVersion)) { return array('result' => 'warning', 'message' => $this->install->lexicon('sqlsrv_version_server_nf'),'version' => $sqlsrvVersion); } $sqlsrv_ver_comp = version_compare($sqlsrvVersion,'10.50.0','>='); if (!$sqlsrv_ver_comp) { /* ancient driver warning */ return array('result' => 'failure','message' => $this->install->lexicon('sqlsrv_version_fail',array('version' => $sqlsrvVersion)),'version' => $sqlsrvVersion); } else { return array('result' => 'success','message' => $this->install->lexicon('sqlsrv_version_success',array('version' => $sqlsrvVersion)),'version' => $sqlsrvVersion); } }
public function version() { if (!empty($this->connect)) { $info = sqlsrv_server_info($this->connect); return $info['SQLServerVersion']; } else { return false; } }
/** * Get the version of the database connector. * * @return string The database connector version. * * @since 12.1 */ public function getVersion() { $this->connect(); $version = sqlsrv_server_info($this->connection); return $version['SQLServerVersion']; }
/** * * @return multitype: Returns an associative array as described in the following table: (Key -- Value ) * ============================================== * CurrentDatabase The connected-to database * ============================================== SQLServerVersion The SQL Server version. SQLServerName The name of the server. */ public function getSQLServerInfo() { return sqlsrv_server_info($this->dbconnection); }
/** * {@inheritdoc} */ public function getServerVersion() { $serverInfo = sqlsrv_server_info($this->conn); return $serverInfo['SQLServerVersion']; }
/** * (non-PHPdoc) * @see DBManager::getDbInfo() * @return array */ public function getDbInfo() { $info = array_merge(sqlsrv_client_info(), sqlsrv_server_info()); return $info; }
function ServerInfo() { global $ADODB_FETCH_MODE; if ($this->fetchMode === false) { $savem = $ADODB_FETCH_MODE; $ADODB_FETCH_MODE = ADODB_FETCH_NUM; } else { $savem = $this->SetFetchMode(ADODB_FETCH_NUM); } $arrServerInfo = sqlsrv_server_info($this->_connectionID); $arr['description'] = $arrServerInfo['SQLServerName'] . ' connected to ' . $arrServerInfo['CurrentDatabase']; $arr['version'] = $arrServerInfo['SQLServerVersion']; //ADOConnection::_findvers($arr['description']); return $arr; }
/** * Database version number. * * @return string */ public function version() { if (isset($this->data_cache['version'])) { return $this->data_cache['version']; } if (!$this->conn_id or ($info = sqlsrv_server_info($this->conn_id)) === false) { return false; } return $this->data_cache['version'] = $info['SQLServerVersion']; }