sqlite3.dll was not found . . . try this fix

Having Problems With sqlite3.dll ?

I was trying to install the latest version of Webuilder on Vista, and kept getting the following message.

“This application failed to start because sqlite3.dll was not found. Re-installing the application may fix this problem.”

I contacted Webuilder support and they said I should try to re-install PHP. This didn’t make any difference. I don’t know if the problem is dependent on the way you install PHP, but I’ve found by discovering which of the DLL’s included in the PHP build was relying on sqlite3.dll, that the solution is to do the following.

The Fix

  1. Open your php.ini file
  2. Find the DLLs at the bottom of php.ini that have been included in the build and look for the section called [PHP_PDO_SQLITE_EXTERNAL], then comment out the line referring to the php_pdo_sqlite_external.dll as I have done below.
  3. Note that php_pdo_sqlite_external.dll relies on sqlite3.dll which is external to the PHP build so doesn’t exist unless you go looking for it and add it in yourself. As far as I know neither php_pdo_sqlite_external.dll nor sqlite3.dll are absolutely necessary so all they are doing is causing me and loads of other people headaches.
  4. So I commented it out the inclusion of the php_pdo_sqlite_external.dll. Once you comment it out, it will no longer screw up any application that wants to use the php.exe file. Which in my case is Webuilder. See below in red. A ; is placed in front of php_pdo_sqlite_external.dll.

[PHP_PDO]
;extension=php_pdo.dll
[PHP_PDO_FIREBIRD]
extension=php_pdo_firebird.dll
[PHP_PDO_MYSQL]
extension=php_pdo_mysql.dll
[PHP_PDO_SQLITE]
extension=php_pdo_sqlite.dll
[PHP_PDO_SQLITE_EXTERNAL]
;extension=php_pdo_sqlite_external.dll

[PHP_PDO_USER]
extension=php_pdo_user.dll
[XDebug]
xdebug.profiler_output_dir=”C:\Program Files\phpDesigner 2008\PHP\tmp”
[PHP_GD2]
extension=php_gd2.dll
[PHP_DOMXML]
extension=php_domxml.dll
[PHP_FILEINFO]
extension=php_fileinfo.dll