/** * This function returns the version string. * * @access public * @author Thorsten Rinne <*****@*****.**> * @since 2005-04-16 */ function client_version() { $client = db2_client_info($this->conn); $ver = $client->DRIVER_NAME . ' ' . $client->DRIVER_VER; return $ver; }
public function getDbInfo() { $this->getDatabase(); $server = @db2_server_info($this->database); if (is_object($server)) { $server = get_object_vars($server); } else { $server = null; } $client = @db2_client_info($this->database); if (is_object($client)) { $client = get_object_vars($client); } else { $client = null; } return array("IBM DB2 Client Info" => $client, "IBM DB2 Server Info" => $server); }
date_default_timezone_set("Asia/Bangkok"); require_once '../../packages/autoload.php'; /* Connect Database Manager Partial : Production */ // /* เชื่อมต่อ DB2 */ $driver_db2 = "{IBM DB2 ODBC DRIVER}"; $database_db2 = "iWLMA"; $hostname_db2 = "172.16.194.210"; $port_db2 = 50000; $user_db2 = "db2admin"; $password_db2 = "password"; $conn_string_db2 = "DRIVER={$driver_db2};DATABASE={$database_db2};"; $conn_string_db2 .= "HOSTNAME={$hostname_db2};PORT={$port_db2};PROTOCOL=TCPIP;"; $conn_string_db2 .= "UID={$user_db2};PWD={$password_db2};"; try { $conn_db2 = db2_connect($conn_string_db2, '', ''); $client = db2_client_info($conn_db2); // if ($client) { // echo var_dump($client->APPL_CODEPAGE); // echo "DRIVER_NAME: "; var_dump( $client->DRIVER_NAME ); // echo "DRIVER_VER: "; var_dump( $client->DRIVER_VER ); // echo "DATA_SOURCE_NAME: "; var_dump( $client->DATA_SOURCE_NAME ); // echo "DRIVER_ODBC_VER: "; var_dump( $client->DRIVER_ODBC_VER ); // echo "ODBC_VER: "; var_dump( $client->ODBC_VER ); // echo "ODBC_SQL_CONFORMANCE: "; var_dump( $client->ODBC_SQL_CONFORMANCE ); // echo "APPL_CODEPAGE: "; var_dump( $client->APPL_CODEPAGE ); // echo "CONN_CODEPAGE: "; var_dump( $client->CONN_CODEPAGE ); // } else { // echo "Error"; // } if (!$conn_db2) { echo db2_conn_errormsg();