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手册 - N: Connecting to Microsoft SQL Server and Sybase databases

用户评论:

ulisse at atc dot bologna dot it (11-Mar-2010 01:38)

on Linux ppc64 / PHP 5.1.2 / freetds-0.64 works well this way: <?php // ... $dbh = new PDO("dblib:host=$hostdb;dbname=$dbname", $usr, $psw); // ... ?>

slach at 74mail dot ru (04-Feb-2009 10:11)

when you connect to non standart 1433 port for win32 use DSN like 'mssql:host=hostname,port;dbname=database' for FreeTDS and DB-Lib use DSN like 'mssql:host=hostname:port;dbname=database'