What are some differences in setup or configuration between Windows XP and Windows 8 when working with MS ACCESS databases in PHP?

One key difference in setup between Windows XP and Windows 8 when working with MS ACCESS databases in PHP is the ODBC driver configuration. Windows XP uses the Microsoft Access ODBC driver, while Windows 8 requires the installation of the Access Database Engine to connect to MS ACCESS databases. Additionally, the connection string may need to be adjusted to reflect the different driver names. 

// Windows XP configuration
$dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:/path/to/database.mdb";

// Windows 8 configuration
$dsn = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:/path/to/database.mdb";

Keywords

Windows XP Windows 8 MS ACCESS PHP configuration setup

Related Questions