Bug #77252 [Opn->Fbk]: PDO ODBC.accdb cannot connect

Edit report at https://bugs.php.net/bug.php?id=77252&edit=1 ID: 77252 Updated by: cmb@php.net Reported by: xxalfa at gmail dot com Summary: PDO ODBC.accdb cannot connect -Status: Open +Status: Feedback Type: Bug Package: PDO ODBC Operating System: Windows PHP Version: 7.3.0 -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: That works fine for me with current PHP 7.3. Maybe there is a permission issue in your setup? Previous Comments: ------------------------------------------------------------------------ [2018-12-06 16:48:52] xxalfa at gmail dot com Description: ------------ Fatal error: Uncaught PDOException: SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][ODBC Driver Manager] The data source name was not found, and no default driver was specified in C:\test.php:29 C:\test.php(29): PDO->__construct('odbc:Driver={Mi...') With an older PHP version it worked. Test script: --------------- <?php //------------------------------------------------- // HEAD //------------------------------------------------- declare( strict_types = 1 ); error_reporting( -1 ); ini_set( 'html_errors', '0' ); ini_set( 'display_errors', '1' ); define( 'CORE_DIR', dirname( __FILE__ ) . DIRECTORY_SEPARATOR ); header( 'Content-Type:text/plain' ); //------------------------------------------------- // CODE //------------------------------------------------- echo PHP_VERSION . PHP_EOL; extension_loaded( 'pdo_odbc' ) or trigger_error( 'The pdo odbc extension is required.', E_USER_ERROR ); $database_path = CORE_DIR . 'test.accdb'; file_exists( $database_path ) or trigger_error( 'Could not find database file.', E_USER_ERROR ); $database = new PDO( 'odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)}; Dbq=' . $database_path ); // $database = new PDO( 'odbc:Driver={Microsoft Access Driver (*.accdb)}; Dbq=' . $database_path . '; Uid=; Pwd=;' ); // $database = odbc_connect( 'Driver={Microsoft Access Driver (*.mdb, *.accdb)}; Dbq=' . $database_path, '', ''); ?> ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=77252&edit=1