PHP Manual
MS SQL Server (PDO)
Connecting to MS SQL Server and SQL Azure databases

PDO_SQLSRV DSN

(No version information available, might only be in Git)

PDO_SQLSRV DSN — Connecting to MS SQL Server and SQL Azure databases

说明

The PDO_SQLSRV Data Source Name (DSN) is composed of the following elements:

DSN prefix: The DSN prefix is sqlsrv:.
APP: The application name used in tracing.
ConnectionPooling: Specifies whether the connection is assigned from a connection pool (1 or TRUE) or not (0 or FALSE).
Database: The name of the database.
Encrypt: Specifies whether the communication with SQL Server is encrypted (1 or TRUE) or unencrypted (0 or FALSE).
Failover_Partner: Specifies the server and instance of the database's mirror (if enabled and configured) to use when the primary server is unavailable.
LoginTimeout: Specifies the number of seconds to wait before failing the connection attempt.
MultipleActiveResultSets: Disables or explicitly enables support for multiple active Result sets (MARS).
QuotedId: Specifies whether to use SQL-92 rules for quoted identifiers (1 or TRUE) or to use legacy Transact-SQL rules (0 or FALSE).
Server: The name of the database server.
TraceFile: Specifies the path for the file used for trace data.
TraceOn: Specifies whether ODBC tracing is enabled (1 or TRUE) or disabled (0 or FALSE) for the connection being established.
TransactionIsolation: Specifies the transaction isolation level. The accepted values for this option are PDO::SQLSRV_TXN_READ_UNCOMMITTED, PDO::SQLSRV_TXN_READ_COMMITTED, PDO::SQLSRV_TXN_REPEATABLE_READ, PDO::SQLSRV_TXN_SNAPSHOT, and PDO::SQLSRV_TXN_SERIALIZABLE.
TrustServerCertificate: Specifies whether the client should trust (1 or TRUE) or reject (0 or FALSE) a self-signed server certificate.
WSID: Specifies the name of the computer for tracing.

范例

Example #1 PDO_SQLSRV DSN examples

The following example shows how to connecto to a specified MS SQL Server database:

$c = new PDO("sqlsrv:Server=localhost;Database=testdb", "UserName", "Password");

The following example shows how to connect to a MS SQL Server database on a specified port:

$c = new PDO("sqlsrv:Server=localhost,1521;Database=testdb", "UserName", "Password");

The following example shows how to connecto to a SQL Azure database with server ID 12345abcde. Note that when you connect to SQL Azure with PDO, your username will be UserName@12345abcde (UserName@ServerId).

$c = new PDO("sqlsrv:Server=12345abcde.database.windows.net;Database=testdb", "UserName@12345abcde", "Password");

php frontbase 函数 list databases available on a frontbase server php mssql 函数关闭ms sql server链接 php mssql 函数打开ms sql server链接 php mssql 函数 executes a stored procedure on a ms sql server database php mysqlnd ms 函数查询给定的 sql 会发送给 master、slave 还是最后使用的 mysql server 执行。php sqlite pdo registers a user defined function for use in sql statements php 4d pdo connecting to 4d sql server php cubrid pdo connecting to cubrid databases php ms sql server pdo connecting to microsoft sql server and sybase databases php pdo 驱动 microsoft sql server and sybase functions pdo dblib php firebird pdo connecting to firebird databases php ibm pdo connecting to ibm databases php informix pdo connecting to informix databases php mysql pdo connecting to mysql databases php oracle pdo connecting to oracle databases php odbc and db2 pdo connecting to odbc or db2 databases php postgresql pdo connecting to postgresql databases php sqlite pdo connecting to sqlite databases php ms sql server pdo connecting to ms sql server and sql azure databases php pdo 驱动 microsoft sql server functions pdo sqlsrv