Connecting to Access Database with PHP

How to Connect to an Access Database with PHP

Note: This only works on our Windows servers.

1. Create a DSN in WCP
2. Use the following code example:

<?php
$DSN="myODBC_DSN";
$DSN_User="";
$DSN_Passwd="";
$QueryString="SELECT id, FirstName, LastName, Email FROM tblContact";
 
$Connect = odbc_connect( $DSN, $DSN_User, $DSN_Passwd );
$Result = odbc_exec( $Connect, $QueryString );
?>