[edit] Last updated: Sat, 07 Jan 2012

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 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.

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

ulisse at atc dot bologna dot it 11-Mar-2010 05: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 02: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