I am doing some research on providing a new front end for our Informix
Server V9.3 HP-UX 11.1i (no option of upgrade primary reason looking
to put new front end on)

Setup a local webserver on Windows XP Machine, running Apache 2.2/PHP
5.2.13. (company politics means I have no root access to Unix box
where our IDS server is hosted.)

I have established and ODBC connection using the SDK 2.6 and can
retrieve queries using the odbc functionality within PHP.

However, my research is leading me towards using an OpenSource
framework as the base for the frontend(possibly Symfony, or
CodeIgniter both of which make use of data abstraction models using
PDO within PHP.

After a day of searching finally found a compatible pdo_informix.dll
(http://www.topdll.com/download/php_pdo_informix.dll?
q=13044fbfd46d65f2ac1f4655014ea8c8, if anyone else is searching as a
lot of people seem to be)

Installed .dll, restarted webserver, and confirmed in php.ini that the
pdo is installed.

However, I cannot make connection to my database using the PDO object
(still works under ODBC) I have followed the instructions in

http://www.php.net/manual/en/ref.pdo...connection.php

I have attempted both duplicatating the DNS name used in my ODBC
connection and "InfDrv33" as specified in manual but both recieved
error along lines 'PDOException' with message 'SQLSTATE=28000,
SQLDriverConnect: -951 sqlerrm(SYSTEM)'

Not sure if its the latest PDO driver not compatible with our old
version of the database server or there is something else I am
missing. If anyone has managed to configure a similar setup, any
advice or tips greatly appreciated.

Hello!
An excelent material was published this year, about basics
implementations for several kinds of development clients
acessing Informix databases, by Mr Jacques Roy.
I couldn´t find the link to download it, but I am sending it to you
personally attached, ok?

Hope it helps you to manage PDO informix driver.
Best regards.

Em 15/07/2010 11:39, armsiee escreveu:

--

Alexandre Marini

Tecnologia da Informação - DBA

msn: alexandre_marini (AT) hotmail (DOT) com

SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix

Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>

IBM Informix Dynamic Server Certified Professional V10 / V11

On Jul 15, 5:20*pm, Alexandre Marini <amar... (AT) fazenda (DOT) ms.gov.br>
wrote:
Thanks Alexandre useful document.

For the record: Everything fine with the install. Just had to pass in
user and pwd for PDO object connection hich is not required by the
ODBC connection.