Hello, I'm attempting to connect to a PDO SQLite database. All I have done so far is enable these extensions in the PHP.ini file:
extension=php_pdo.dll
extension=php_pdo_firebird.dll
extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll
extension=php_pdo_oci.dll
extension=php_pdo_oci8.dll
extension=php_pdo_odbc.dll
extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll
The one I haven't enabled though is: extension=php_pdo_informix.dll
I have the .dll in my "ext" folder of my PHP directory, the problem is when attempting to restart the server with the extension enabled. It always returns an error message mentioning that "ICLIT098.dll was not found". I know it's not my computer because I searched for it, also Google returned no results on the file so I have no leads to retrieving the file that will make that error go away. So for now I have "php_pdo_informix.dll" disabled.
Anyways, I'm using this script:
<?php
try {
$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
foreach ($dbh->query('SELECT * from FOO') as $row) {
print_r($row);
}
$dbh = null;
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "<br/>";
die();
}
?>
to attempt connecting to the supposedly databse. Whenever I execute the script I get an error reading: Error!: SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'localhost' (10061)
Either the database doesn't exist, or the "php_pdo_informix.dll" file which is missing the "ICLIT098.dll" file is required to connect to the database.
Here is the information on my currently enabled SQLite module:
pdo_sqlite
PDO Driver for SQLite 3.x: enabled
PECL Module version: 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6 2006/01/01 12:50:12 sniper Exp $
SQLite Library: 3.3.7undefined
Any assistance is greatly appreciated.