PDO Drivers

Cuprins

The following drivers currently implement the PDO interface:

Driver name Supported databases
PDO_CUBRID Cubrid
PDO_DBLIB FreeTDS / Microsoft SQL Server / Sybase
PDO_FIREBIRD Firebird
PDO_IBM IBM DB2
PDO_INFORMIX IBM Informix Dynamic Server
PDO_MYSQL MySQL 3.x/4.x/5.x
PDO_OCI Oracle Call Interface
PDO_ODBC ODBC v3 (IBM DB2, unixODBC and win32 ODBC)
PDO_PGSQL PostgreSQL
PDO_SQLITE SQLite 3 and SQLite 2
PDO_SQLSRV Microsoft SQL Server / SQL Azure
PDO_4D 4D

add a note add a note

User Contributed Notes 2 notes

up
0
fleduc dot perso at gmail dot com
2 months ago
Watch out!

If you use PDO SQLSRV on windows 7, using 32 bit php on XAMMP, you might encounter driver problems : "This extension requires the Microsoft ODBC Driver 11 for SQL Server to communicate with SQL Server"

The reason, Microsoft 32-bit ODBC driver doesn't install properly on 64-bit Windows 7.

Check the solution to PDO SQLSRV driver problem here in [StackOverflow][1]

https://stackoverflow.com/a/46245990/1330248
up
0
frankjustme2004 at yahoo dot com
1 year ago
For those seeking Netezza access you can use php_odbc or pdo_odbc. They both work flawlessly. Found some issues between Web vs CLI that were around LD_LIBRARY_PATH setting in Unix. As long as this is set in Unix and Apache environment it will work.
To Top