Last updated: Fri, 30 Oct 2009

PDO_DBLIB DSN

(PECL PDO_DBLIB >= 0.9.0)

PDO_DBLIB DSN — Connecting to Microsoft SQL Server and Sybase databases

Beschreibung

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 FreeTDS libraries, mssql: if PDO_DBLIB was linked against the Microsoft SQL Server libraries, or dblib: if linked against any other variety of DB-lib.
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.

Beispiele

Beispiel #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

add a note User Contributed Notes
PDO_DBLIB DSN

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'

add a note

Firebird/Interbase (PDO)

MS SQL Server (PDO)

Last updated: Fri, 30 Oct 2009