X64 Wamp + Oracle environment setup

Recently, Windows 7x64 has been used, causing many inconveniences in terms of 64-bit compatibility (most of which are problems in the process of mutual calls between x86 and x64 ). Sort the information as follows:

1. Background
After the system is changed, we often reinstall various "bulky" items. Among them, vs 2008 automatically installs the x64 version, and MySQL also installs the x64 version officially provided. Apache and PHP still use the original x86 version. Navicat Lite is only available in x86 versions, and the system automatically sets the compatibility mode for it. Because the x64 system is supported in the official instructions, ODT (with odac) is directly installed, and x86 is also found. Everything seemed smooth, so the first day passed.
2. Problems
First, we found that php_mysql and php_mysqli could not be loaded. After checking the log, we found that PHP in 32-Bit mode could not be loaded into the 64-bit MYSQL client. Therefore, we tried to replace Apache and PHP with 64-bit. After searching by multiple parties, the corresponding unofficial version is found, but it cannot be started. Therefore, the 64-bit MySQL is discarded and an XAMPP is directly installed. Now both phpMyAdmin and navicat can be used normally, and php_oci8 can be used normally.
3. About vs 2008 and Oracle
One day, in an oracle project, vs 2008 reported an exception when calling nhib.pdf to access Oracle: "A 32-bit Oracle client cannot be used in a 64-bit program ". After querying the Oracle official website, we found that only the instant client has a separate x64 version, and the ODT does not. Very depressing. After you try to replace the existing ODT with the x64 Instant Client, PHP and navicat cannot call OCI again.
4. Solution
Install the x64 Instant Client, decompress the x86 Instant Client, and copy it to the Apache bin directory. php successfully calls OCI.
In the navicat option, the location of the 32-bit OCI. dll and sqlplus.exe is manually specified and can be used normally.
5. Summary
Windows 7x64
Visual Studio 2008 SP1 x64
XAMPP x86
After environment variables are configured with ODT with odac x86, replace the file with the same name with Oracle Instant Client x64
Oracle Instant Client x86 uses the Application Path

Technorati labels: x64, Oracle, Apache, PHP, MySQL, XAMPP,