DSN -- The Data Source Name
Description
To connect to a database through PEAR::MDB2, you have to create a
valid DSN - data source name. This DSN
consists in the following parts:
|
phptype:
Database backend used in PHP (i.e. mysql
, pgsql etc.)
|
|
dbsyntax:
Database used with regards to SQL syntax etc.
|
|
protocol:
Communication protocol to use ( i.e. tcp,
unix etc.)
|
|
hostspec:
Host specification (hostname[:port])
|
|
database:
Database to use on the DBMS server
|
|
username:
User name for login
|
|
password:
Password for login
|
|
proto_opts:
Maybe used with protocol
|
|
option:
Additional connection options in URI query string format.
options get separated by &.
The Following table shows a non complete list of options:
|
Tableau 39-1. List of options
| Name | Description | Type |
|---|
| charset |
Some backends support setting the client charset. (Invokes
setCharset(string $charset, [resource $connection = null])
| string |
| new_link [boolean] |
Some RDBMS do not create new connections when connecting to the same host
multiple times. If this option is set to TRUE it will attempt to force
a new connection.
| boolean |
The DSN can either be provided as an associative array or
as a string.
The array format is preferred, since it doesn't require a further parsing step
(see the Connecting
chapter for an example).
The string format of the supplied DSN is in its fullest form:
phptype(dbsyntax)://username:password@protocol+hostspec/database?option=value |
Most variations are allowed:
phptype://username:password@protocol+hostspec:110//usr/db_file.db
phptype://username:password@hostspec/database
phptype://username:password@hostspec
phptype://username@hostspec
phptype://hostspec/database
phptype://hostspec
phptype:///database
phptype:///database?option=value&anotheroption=anothervalue
phptype(dbsyntax)
phptype |
The currently supported database backends are:
fbsql -> FrontBase
ibase -> InterBase / Firebird (requires PHP 5)
mssql -> Microsoft SQL Server (NOT for Sybase. Compile PHP --with-mssql)
mysql -> MySQL
mysqli -> MySQL (supports new authentication protocol) (requires PHP 5)
oci8 -> Oracle 7/8/9/10
pgsql -> PostgreSQL
querysim -> QuerySim
sqlite -> SQLite 2 |
A second DSN format is supported
phptype(syntax)://user:pass@protocol(proto_opts)/database |
If your database, option values,
username or password
contain characters used to delineate DSN parts, you
can escape them via URI hex encodings:
: = %3a / = %2f @ = %40
+ = %2b ( = %28 ) = %29
? = %3f = = %3d & = %26 |
| Avertissement |
Please note, that some features may be not supported by all
database backends.
|
|
Introduction (Previous)
|
(Next) Connecting
|
|
|
Download Documentation
|
Last updated: Sun, 20 Jul 2008 |
|
Do you think that something on this page is wrong? Please file a bug report or add a note.
|
| User Notes: |
Note by: mapopa@gmail.com
if you are using firebird on linux then you need to add an extra slash to the db path like this
$mdb2 =& MDB2::connect(’ibase://sysdba:masterkey@localhost//var/lib/firebird/2.1/data/employee.fdb’);
and you can check the result with the extra debug info
if (PEAR::isError($mdb2)) {
die($mdb2->getMessage(). ‘,’ . $mdb2->getDebugInfo());
If you use Firebird database, specify dbsyntax='firebird'.
For example, "ibase(firebird)://SYSDBA:masterkey@localhost/dbname".
In current version (MDB2_Driver_ibase 1.4.1) this value affects only limiting queries (by setLimit(limit,offset))
|
|
