HOME |
(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:
The DSN prefix is sqlsrv:
.
The application name used in tracing.
Specifies whether the connection is assigned from a connection pool
(1 or TRUE
) or not (0 or FALSE
).
The name of the database.
Specifies whether the communication with SQL Server is encrypted
(1 or TRUE
) or unencrypted (0 or FALSE
).
Specifies the server and instance of the database's mirror (if enabled and configured) to use when the primary server is unavailable.
Specifies the number of seconds to wait before failing the connection attempt.
Disables or explicitly enables support for multiple active Result sets (MARS).
Specifies whether to use SQL-92 rules for quoted identifiers (1 or TRUE
)
or to use legacy Transact-SQL rules (0 or false).
The name of the database server.
Specifies the path for the file used for trace data.
Specifies whether ODBC tracing is enabled (1 or TRUE
) or disabled
(0 or FALSE
) for the connection being established.
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.
Specifies whether the client should trust (1 or TRUE
) or reject
(0 or FALSE
) a self-signed server certificate.
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");