Archives for March 2007
Separate Instances of MySQL 4.0 and MySQL 4.1 on Windows
Assuming you already have MySQL 4.0 running on its default port (3306), install MySQL 4.1 and set its service name to MySQL41 and its port to 3307.
The ASP connection string is as follows:
“driver={MYSQL ODBC 3.51 Driver};” & _
“server=localhost;port=3307;” & _
“uid=user1;pwd=a_password;database=db1″
The PHP connection method is as follows:
$c = mysql_connect(”localhost:3307″, “user1″, “a_password”);
mysql_select_db(”db1″, $c);
Apache 2.2 + PHP 5.1.1 on Windows
After adding the following lines to the end of httpd.conf:
LoadModule php5_module “c:/php/php5apache2.dll”
AddType application/x-httpd-php .php
PHPIniDir “C:/php”
You restart Apache and get the following error:
The Apache2.2 service terminated with service-specific error 1 (0×1)
The solution is to download php5apache2.dll-php5.1.x.zip courtesy of Steffen. Overwrite php5apache2.dll in your PHP folder and copy httpd.exe.manifest to your Apache2 bin folder.
