|
|
Connect From VB to SQL Server
|
|
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)
