This file may be required for SPF functions to work
<?php $FP7Data = str_replace('\\','/', getenv('FP7Data')); //De-windblowz path if($FP7Data == '') die('Please Fix your FP7Data Environment Variable'); //Make sure variable is set if(substr($FP7Data,-1,1) != '/') $FP7Data .= '/'; //Cleanup path if(!file_exists($FP7Data . 'Database.dsn')) die('Please open your database and click START'); // Makesure DSN exists $DSN = parse_ini_file(($FP7Data . 'Database.dsn'), true, INI_SCANNER_RAW); $DSN = array_change_key_case($DSN, CASE_UPPER); if(!array_key_exists('ODBC',$DSN)) die('Unrecoverable DSN File Error [ODBC]'); if(!array_key_exists('DRIVER',$DSN['ODBC'])) { echo 'DSN File Error [DRIVER] "Microsoft Access Driver (*.mdb)" assumed' . "\n"; $DSN['ODBC']['DRIVER'] = 'Microsoft Access Driver (*.mdb)'; } if(!array_key_exists('UID',$DSN['ODBC'])) { echo "DSN File Error [UID] Admin assumed\n"; $DSN['ODBC']['UID'] = 'Admin'; } if(!array_key_exists('FIL',$DSN['ODBC'])) { echo 'DSN File Error [FIL] "MS Access" assumed' . "\n"; $DSN['ODBC']['FIL'] = 'MS Access'; } if(!array_key_exists('DBQ',$DSN['ODBC'])) die('Unrecoverable DSN File Error [DBQ]'); $DSN['ODBC']['DBQ'] = str_replace('?',' ',$DSN['ODBC']['DBQ']); $PDODSN = 'odbc:'; foreach($DSN['ODBC'] as $key=>$value){ $PDODSN .= $key . '=' . $DSN['ODBC'][$key] . ';'; } try { $dbh = new PDO($PDODSN); } catch (PDOException $e) { die( 'Connection failed: ' . $e->getMessage()); } ?>