I have compiled (Visual Studio 6) pdo_informix on Windows and have run the following script:

<?php

$conn = new PDO("informix:DSN=myDSN", "user", "***");

$sql = "DROP TABLE test";
$stmt = $conn->exec($sql);
$sql = "CREATE TABLE test (id INTEGER, data VARCHAR(50))";
$stmt = $conn->exec($sql);
$sql = "INSERT INTO test (id, data) VALUES (1, 'Kellen')";
$stmt = $conn->exec($sql);
$sql = "SELECT data FROM test WHERE id = ?";
$sth = $conn->prepare($sql);
$line = 1;
$sth->bindParam(1, $line);
$sth->execute();
while ($row = $sth->fetch(PDO::FETCH_NUM)) {
	print_r($row);
}

?>

I am seeing no problems with this script.  I tried to base it off of your original script.  Can you please modify this script and let us know the changes in order to reproduce the defect?

I created the file, under windows it returns [in IIS]
CGI Error
or if run from the command line it just drops back to the command prompt with no returns.

On Unix:
Array
(
    [0] => Kellen
)


Could there be something with my windows dev system that is preventing it from properly compiling? I would assume in that case the dll would not function at all.

Please copy the exact script that I provided in the previous mail, change the connection information appropriately and run the script via the command line.  Paste the output, and the script, from the command line in here.  

This does not appear to be an issue with the pdo_informix code but that of a setup/compile issue.

Let me try recompiling the DLL file and see if that makes any difference. Would you be able to paste the windows build command that you used?

I used the following...but you may need different options:

cscript /nologo configure.js --disable-cgi --enable-cli --with-xml --enable-zlib --without-libxml --without-pdo-sqlite --without-iconv --without-sqlite --enable-pdo --without-gd --with-pdo-informix="C:\Informix",shared

Please provide feedback on this issue.  We will close if there is no response assuming that all has been resolved.

Thanks for the help, I am still trying to track down the problem but it looks like for some reason the production system is using an old dll file instead of 1.1.0 which is in the php/ext directory. [Which is something on my end, not something that is a pecl bug]