- PDO_DBLIB
The DSN prefix is either sybase:
or mssql: depending on which libraries
it was linked against during compilation.
sybase:host=localhost; dbname=testdb
mssql:host=localhost; dbname=testdb
- PDO_FIREBIRD
firebird:User=john;Password=mypass;Database=DATABASE.GDE;DataSource=localhost;Port=3050
- PDO_MYSQL
mysql:host=localhost;dbname=testdb
- PDO_OCI
To connect via tnsnames.ora, use:
oci:mydb
If using instantclient, use:
oci:dbname=//localhost:1521/testdb
- PDO_ODBC
odbc:DSN=SAMPLE;UID=john;PWD=mypass
DSN=SAMPLE refers to the SAMPLE data source configured in the ODBC driver manager.
- PDO_PGSQL
pgsql:host=localhost port=5432 dbname=testdb user=john password=mypass
Note, by passing user and password
in the DSN, the username
and password parameters become optional.
If specified, they are glued to the end of the connection string.
- PDO_SQLITE
sqlite:/path/to/database
To create a database in memory, use:
sqlite::memory: