sqlsrv_client_info(3) [php man page]

SQLSRV_CLIENT_INFO(3)													     SQLSRV_CLIENT_INFO(3)

sqlsrv_client_info - Returns information about the client and specified connection

SYNOPSIS

       array sqlsrv_client_info (resource  $conn)

DESCRIPTION

	Returns information about the client and specified connection

PARAMETERS

	      o $conn
		- The connection about which information is returned.

RETURN VALUES

	Returns an associative array with keys described in the table below. Returns FALSE otherwise.

       Array returned by sqlsrv_client_info

       +--------------+-------------------------------------------------+
       |     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)	|
       |	      | 						|
       +--------------+-------------------------------------------------+
EXAMPLES

       Example #1

	      sqlsrv_client_info(3) example

	      <?php
	      $serverName = "serverNamesqlexpress";
	      $connOptions = array("UID"=>"username", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connOptions );

	      if( $conn === false ) {
		  die( print_r( sqlsrv_errors(), true));
	      }

	      if( $client_info = sqlsrv_client_info( $conn)) {
		  foreach( $client_info as $key => $value) {
		      echo $key.": ".$value."<br />";
		  }
	      } else {
		  echo "Error in retrieving client info.<br />";
	      }
	      ?>

SEE ALSO

       sqlsrv_server_info(3).

PHP Documentation Group 												     SQLSRV_CLIENT_INFO(3)

SQLSRV_CONNECT(3)														 SQLSRV_CONNECT(3)

sqlsrv_connect - Opens a connection to a Microsoft SQL Server database

SYNOPSIS

       resource sqlsrv_connect (string	$serverName, [array  $connectionInfo])

DESCRIPTION

	Opens  a  connection  to a Microsoft SQL Server database. By default, the connection is attempted using Windows Authentication. To connect
       using SQL Server Authentication, include "UID" and "PWD" in the connection options array.

PARAMETERS

	      o $serverName
		- The name of the server to which a connection is established. To connect to a specific instance, follow the server  name  with  a
		forward slash and the instance name (e.g. serverNamesqlexpress).

	      o $connectionInfo
		-  An associative array that specifies options for connecting to the server. If values for the UID and PWD keys are not specified,
		the connection will be attempted using Windows Authentication. For a complete  list  of  supported  keys,  see	SQLSRV	Connection
		Options.

RETURN VALUES

	A connection resource. If a connection cannot be successfully opened, FALSE is returned.

EXAMPLES

       Example #1

	      Connect using Windows Authentication.

	      <?php
	      $serverName = "serverNamesqlexpress"; //serverNameinstanceName

	      // Since UID and PWD are not specified in the $connectionInfo array,
	      // The connection will be attempted using Windows Authentication.
	      $connectionInfo = array( "Database"=>"dbName");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);

	      if( $conn ) {
		   echo "Connection established.<br />";
	      }else{
		   echo "Connection could not be established.<br />";
		   die( print_r( sqlsrv_errors(), true));
	      }
	      ?>

       Example #2

	      Connect by specifying a user name and password.

	      <?php
	      $serverName = "serverNamesqlexpress"; //serverNameinstanceName
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);

	      if( $conn ) {
		   echo "Connection established.<br />";
	      }else{
		   echo "Connection could not be established.<br />";
		   die( print_r( sqlsrv_errors(), true));
	      }
	      ?>

       Example #3

	      Connect on a specifed port.

	      <?php
	      $serverName = "serverNamesqlexpress, 1542"; //serverNameinstanceName, portNumber (default is 1433)
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);

	      if( $conn ) {
		   echo "Connection established.<br />";
	      }else{
		   echo "Connection could not be established.<br />";
		   die( print_r( sqlsrv_errors(), true));
	      }
	      ?>

NOTES

	By  default, the sqlsrv_connect(3) uses connection pooling to improve connection performance. To turn off connection pooling (i.e. force a
       new connection on each call), set the "ConnectionPooling" option in the $connectionOptions array to 0 (or FALSE). For more information, see
       SQLSRV Connection Pooling.

	The  SQLSRV  extension does not have a dedicated function for changing which database is connected to. The target database is specified in
       the $connectionOptions array that is passed to sqlsrv_connect. To change the database on an open connection, execute  the  following  query
       "USE dbName" (e.g. sqlsrv_query($conn, "USE dbName")).

SEE ALSO

       sqlsrv_close(3), sqlsrv_errors(3), sqlsrv_query(3).

PHP Documentation Group 													 SQLSRV_CONNECT(3)