PDO_DBLIB DSN

(PECL PDO_DBLIB >= 0.9.0)

PDO_DBLIB DSN — Connecting to Microsoft SQL Server and Sybase databases

说明

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

DSN prefix

The DSN prefix is sybase: if PDO_DBLIB was linked against the Sybase ct-lib libraries, mssql: if PDO_DBLIB was linked against the Microsoft SQL Server libraries, or dblib: if PDO_DBLIB was linked against the FreeTDS libraries.

host

The hostname on which the database server resides. Defaults to 127.0.0.1.

dbname

The name of the database.

charset

The client character set.

appname

The application name (used in sysprocesses). Defaults to "PHP Generic DB-lib" or "PHP freetds".

secure

Currently unused.

范例

Example #1 PDO_DBLIB DSN examples

The following examples show a PDO_DBLIB DSN for connecting to Microsoft SQL Server and Sybase databases: 

mssql:host=localhost;dbname=testdb
sybase:host=localhost;dbname=testdb
dblib:host=localhost;dbname=testdb

相关文章
php 针对各数据库系统对应的扩展 microsoft sql serverphp 针对各数据库系统对应的扩展 microsoft sql server driver for phpphp mssql 函数 关闭ms sql server链接php mssql 函数 打开ms sql server链接php mssql 函数 executes a stored procedure on a ms sql server databasephp mysqlnd ms 函数 查询给定的 sql 会发送给 master、slave 还是最后使用的 mysql server 执行。php sqlsrv 函数 opens a connection to a microsoft sql server databasephp 4d pdo connecting to 4d sql serverphp cubrid pdo connecting to cubrid databasesphp ms sql server pdo connecting to microsoft sql server and sybase databasesphp pdo 驱动 microsoft sql server and sybase functions pdo dblib php firebird pdo connecting to firebird databasesphp ibm pdo connecting to ibm databasesphp informix pdo connecting to informix databasesphp mysql pdo connecting to mysql databasesphp oracle pdo connecting to oracle databasesphp odbc and db2 pdo connecting to odbc or db2 databasesphp sqlite pdo connecting to sqlite databasesphp ms sql server pdo connecting to ms sql server and sql azure databasesphp pdo 驱动 microsoft sql server functions pdo sqlsrv
关注编程学问公众号