note 103354 deleted from pdo.installation by danbrown
| From: | danbrown@php.net | Date: | Fri, 08 Apr 2011 23:46:26 +0000 |
| Subject: | note 103354 deleted from pdo.installation by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-178651@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.