note 103355 deleted from pdo.installation by cmb
| From: | cmb@php.net | Date: | Fri, 01 Feb 2019 14:36:00 +0000 |
| Subject: | note 103355 deleted from pdo.installation by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-210166@lists.php.net to get a copy of this message | ||
Note Submitter: dtcwee at hotmail dot com
----
You may receive this error when testing a PDO-ODBC connection:
"The specified DSN contains an architecture mismatch between the Driver and Application"
My environment was Windows 7 (64 bit), MySQL ODBC drivers (64 bit), Apache 2.2.17 (32 bit), PHP
5.3.5 (32 bit).
If you are like me, you were testing the PDO-ODBC connection because the native database drivers
were not visible to PHP. Furthermore, the MySQL 32 bit drivers did not work in my environment.
Solution: Your environment has to be 64 bit all the way through.
Install 64 bit versions of Apache and PHP. They are not available from official sources. However,
kind people have compiled some and made them available for download.
As a bonus, the native database drivers suddenly showed up enabled.