- A DNS name can include wild card characters. But the [!INCLUDE[jdbcNoVersion](../../includes/jdbcnoversion_md.md)] does not support wild card matching. That is, abc.com will not match *.com but \*.com will match \*.com.

[*database***.**]*schema***.***table* **in** *data_file* | **out** *data_file*

- **-K***application_intent*

- **-M***multisubnet_failover*

- -S [*protocol*:] *server*[**,***port*]

- **Database=***database_name*

- **Server=***server_name_or_IP_address*

|**Address**|SSPROP_INIT_NETWORKADDRESS|The network address of the server running an instance of [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)]. **Address** is usually the network name of the server, but can be other names such as a pipe, an IP address, or a TCP/IP port and socket address.<br /><br /> If you specify an IP address, make sure that the TCP/IP or named pipes protocols are enabled in [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Configuration Manager.<br /><br /> The value of **Address** takes precedence over the value passed to **Server** in connection strings when using OLE DB Driver for SQL Server. Also note that `Address=;` will connect to the server specified in the **Server** keyword, whereas `Address= ;, Address=.;`, `Address=localhost;`, and `Address=(local);` all cause a connection to the local server.<br /><br /> The complete syntax for the **Address** keyword is as follows:<br /><br /> [*protocol***:**]*Address*[**,***port &#124;\pipe\pipename*]<br /><br /> *protocol* can be **tcp** (TCP/IP), **lpc** (shared memory), or **np** (named pipes). For more information about protocols, see [Configure Client Protocols](../../../database-engine/configure-windows/configure-client-protocols.md).<br /><br /> If neither *protocol* nor the **Network** keyword is specified, OLE DB Driver for SQL Server will use the protocol order specified in [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Configuration Manager.<br /><br /> *port* is the port to connect to, on the specified server. By default, [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] uses port 1433.|

|**Server**|DBPROP_INIT_DATASOURCE|The name of a [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] instance. The value must be either the name of a server on the network, an IP address, or the name of a [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Configuration Manager alias.<br /><br /> When not specified, a connection is made to the default instance on the local computer.<br /><br /> The **Address** keyword overrides the **Server** keyword.<br /><br /> You can connect to the default instance on the local server by specifying one of the following:<br /><br /> **Server=;**<br /><br /> **Server=.;**<br /><br /> **Server=(local);**<br /><br /> **Server=(local);**<br /><br /> **Server=(localhost);**<br /><br /> **Server=(localdb)\\** *instancename* **;**<br /><br /> For more information about LocalDB support, see [OLE DB Driver for SQL Server Support for LocalDB](../../oledb/features/oledb-driver-for-sql-server-support-for-localdb.md).<br /><br /> To specify a named instance of [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)], append **\\***InstanceName*.<br /><br /> When no server is specified, a connection is made to the default instance on the local computer.<br /><br /> If you specify an IP address, make sure that the TCP/IP or named pipes protocols are enabled in [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Configuration Manager.<br /><br /> The complete syntax for the **Server** keyword is as follows:<br /><br /> **Server=**[*protocol***:**]*Server*[**,***port*]<br /><br /> *protocol* can be **tcp** (TCP/IP), **lpc** (shared memory), or **np** (named pipes).<br /><br /> The following is an example of specifying a named pipe:<br /><br /> `np:\\.\pipe\MSSQL$MYINST01\sql\query`<br /><br /> This line specifies named pipe protocol, a named pipe on the local machine (`\\.\pipe`), the name of the [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] instance (`MSSQL$MYINST01`), and the default name of the named pipe (`sql/query`).<br /><br /> If neither a *protocol* nor the **Network** keyword is specified, OLE DB Driver for SQL Server will use the protocol order specified in [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Configuration Manager.<br /><br /> *port* is the port to connect to, on the specified server. By default, [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] uses port 1433.<br /><br /> Spaces are ignored at the beginning of the value passed to **Server** in connection strings when using OLE DB Driver for SQL Server.|

If the DBPROPSET_SQLSERVERSESSION property SSPROP_QUOTEDCATALOGNAMES is VARIANT_TRUE, a quoted identifier can be specified for the catalog name (for example "my.catalog"). When restricting schema rowset output by catalog, the OLE DB Driver for SQL Server recognizes a two-part name containing the linked server and catalog name. For the schema rowsets in the table below, specifying a two-part catalog name as *linked_server***.***catalog* restricts output to the applicable catalog of the named linked server.

{[**?=**]**call***procedure_name*[**(**[*parameter*][**,**[*parameter*]]...**)**]}

4. Specify the desired SQL Server data type by using the appropriate **SQLSRV_SQLTYPE_\*** constant as the fourth parameter in each subarray of the *$params* array. For a complete list of the **SQLSRV_SQLTYPE_\*** constants, see the SQLTYPEs section of [Constants &#40;Microsoft Drivers for PHP for SQL Server&#41;](../../connect/php/constants-microsoft-drivers-for-php-for-sql-server.md). For example, in the code below, *$changeDate*, *$rate*, and *$payFrequency* are specified respectively as the SQL Server types **datetime**, **money**, and **tinyint** in the *$params* array. Because no SQL Server type is specified for *$employeeId* and it is initialized to an integer, the default SQL Server type **integer** is used.