/** * Before class method: set minimun server severity; * otherwise server messages end up on the error stack * and will let the test fail (no error policy). * */ public function setUp() { parent::setUp(); if (function_exists('mssql_min_message_severity')) { mssql_min_message_severity(12); } }
/** * Connects to the MSSQL database. * * \param $settings * An associative array with connection settings: the 'hostname', * 'username' and 'password' indices will be used. */ function connect(array $settings) { is_array($settings) && isset($settings['hostname'], $settings['username'], $settings['password']) or trigger_error('Invalid parameters to connect()', E_USER_ERROR); $this->id =& mssql_pconnect($settings['hostname'], $settings['username'], $settings['password']) or trigger_error(sprintf('Could not connect to databaseserver (%s)', $settings['hostname']), E_USER_ERROR); // suppress warnings if (function_exists('mssql_min_client_severity')) { mssql_min_client_severity(100); } if (function_exists('mssql_min_server_severity')) { mssql_min_server_severity(100); } if (function_exists('mssql_min_message_severity')) { mssql_min_message_severity(100); } if (function_exists('mssql_min_error_severity')) { mssql_min_error_severity(100); } }
function db_connect($query = "SELECT") { global $db_list, $global_db_list; if (!is_array($db_list)) { return true; } if ($this->blogs != '' && preg_match("/(" . $this->blogs . "|" . $this->users . "|" . $this->usermeta . "|" . $this->site . "|" . $this->sitemeta . "|" . $this->sitecategories . ")/i", $query)) { $action = 'global'; $details = $global_db_list[mt_rand(0, count($global_db_list) - 1)]; $this->db_global = $details; } elseif (preg_match("/^\\s*(alter table|create|insert|delete|update|replace) /i", $query)) { $action = 'write'; $details = $db_list['write'][mt_rand(0, count($db_list['write']) - 1)]; $this->db_write = $details; } else { $action = ''; $details = $db_list['read'][mt_rand(0, count($db_list['read']) - 1)]; $this->db_read = $details; } $dbhname = "dbh" . $action; $this->{$dbhname} = @mssql_connect($details['db_host'], $details['db_user'], $details['db_password']); $this->is_mysql = false; if (!$this->{$dbhname}) { $this->bail(sprintf("\n<h1>Error establishing a database connection</h1>\n<p>This either means that the username and password information in your <code>wp-config.php</code> file is incorrect or we can't contact the database server at <code>%s</code>. This could mean your host's database server is down.</p>\n<ul>\n <li>Are you sure you have the correct username and password?</li>\n <li>Are you sure that you have typed the correct hostname?</li>\n <li>Are you sure that the database server is running?</li>\n</ul>\n<p>If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the <a href='http://wordpress.org/support/'>WordPress Support Forums</a>.</p>\n", $details['db_host']), 'db_connect_fail'); } mssql_min_error_severity(0); mssql_min_message_severity(17); @mssql_query('SET TEXTSIZE 2147483647'); $this->select($details['db_name'], $this->{$dbhname}); }
/** * MS SQL DBO driver constructor; sets SQL Server error reporting defaults * * @param array $config Configuration data from app/config/databases.php * @return boolean True if connected successfully, false on error */ function __construct($config, $autoConnect = true) { if ($autoConnect) { if (!function_exists('mssql_min_message_severity')) { trigger_error("PHP SQL Server interface is not installed, cannot continue. For troubleshooting information, see http://php.net/mssql/", E_USER_WARNING); } mssql_min_message_severity(15); mssql_min_error_severity(2); } return parent::__construct($config, $autoConnect); }
/** * Connect to the database * * @param string $host The hostname the database is located at * @param integer $port The port the database is at * @param string $user Username for connecting * @param string $pass Password for connecting * @param string $db The database name * @param boolean $new_link TRUE for establishing a new link to the database, FALSE to re-use an existing one * @param integer $client_flags Database connection flags (see the PHP/MySQL documentation) * @return boolean */ protected function _connect($host, $port, $user, $pass, $db, $new_link, $client_flags) { mssql_min_message_severity(QUICKBOOKS_DRIVER_SQL_MSSQL_MESSAGE_LEVEL); mssql_min_error_severity(QUICKBOOKS_DRIVER_SQL_MSSQL_ERROR_LEVEL); if ($port) { $this->_conn = mssql_connect($host, $user, $pass, $new_link) or die('host: ' . $host . ', user: '******', pass: '******' mysql_error(): ' . mssql_get_last_message()); } else { $this->_conn = mssql_connect($host . ':' . $port, $user, $pass, $new_link) or die('host: ' . $host . ', user: '******', pass: '******' mysql_error(): ' . mssql_get_last_message()); } return mssql_select_db($db, $this->_conn); }
/** * Connect to and select database * * @since 3.0.0 */ function db_connect() { // Make sure the version is the same for your ntwdblib.dll. // The TDS library and the ntwdblib.dll can't be speaking two different protocols. // note we don't OVERWRITE an existing TDSVER environment // a properly set up environment might have this at 8.0 or higher if (false === getenv('TDSVER')) { putenv('TDSVER=70'); } // Set text limit sizes to max BEFORE connection is made ini_set('mssql.textlimit', 2147483647); ini_set('mssql.textsize', 2147483647); if (get_magic_quotes_gpc()) { $this->dbhost = trim(str_replace("\\\\", "\\", $dbhost)); } if (WP_DEBUG) { $this->dbh = mssql_connect($this->dbhost, $this->dbuser, $this->dbpassword); } else { $this->dbh = @mssql_connect($this->dbhost, $this->dbuser, $this->dbpassword); } if (!$this->dbh) { $this->bail(sprintf("\n<h1>Error establishing a database connection</h1>\n<p>This either means that the username and password information in your <code>wp-config.php</code> file is incorrect or we can't contact the database server at <code>%s</code>. This could mean your host's database server is down.</p>\n<ul>\n <li>Are you sure you have the correct username and password?</li>\n <li>Are you sure that you have typed the correct hostname?</li>\n <li>Are you sure that the database server is running?</li>\n</ul>\n<p>If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the <a href='http://wordpress.org/support/'>WordPress Support Forums</a>.</p>\n", $this->dbhost), 'db_connect_fail'); return; } mssql_min_error_severity(0); mssql_min_message_severity(17); @mssql_query('SET TEXTSIZE 2147483647'); $this->ready = true; $this->select($this->dbname, $this->dbh); }
public static function setMinimumServerSeverity() { if (function_exists('mssql_min_message_severity')) { mssql_min_message_severity(12); } }