On Wed, 2011-06-29 at 16:42 -0400, Steve Staples wrote:
> I am trying to connect to an informix database, and using excel and odbc
> it works fine.
>
> I installed the PDO_INFORMIX via:
> pecl download pdo_informix
> phpize
> ./configure --with-pdo-informix=/opt/IBM/informix
> make
> make install
>
> and it all appeard to work... phpinfo() shows that it's enabled, and
> active... and when i do my PDO connection, it fails with this error:
>
> I also installed the CSDK prior to installing the pecl pdo_informix (as
> the php.net docs said)
>
> Fatal error: Uncaught exception 'PDOException' with message
> 'SQLSTATE=HY000, SQLDriverConnect: -23101 [Informix][Informix ODBC
> Driver][Informix]Unspecified System Error = -23101.'
>
> all the values in my code, i was given from my boss, which he used to
> get in with excel and the odbc. the $database has to be the full path
> of the informix table
>
> Also, we cannot even see my local machine hitting the server, yet when i
> try telnet to it, i can connect no issues... so it's not a firewall from
> my machine to it.
>
> Any ideas? or thoughts on how to get this working??
>
> -- code --
> <?php
> $host = "[ipaddress of machine]";
> $port = "[port number]";
> $database = "[actual path of database]";
> $server = "[server]";
> $protocol = "sesoctcp";
> $username = "[username]";
> $password = "[password]";
> $tablename = "[name of the table]";
>
> $db = new PDO("informix:host={$host}; service={$port};
> database={$database}; server={$server}; protocol={$protocol};
> EnableScrollableCursors=1;", $username, $password);
>
> print "Connection Established!\n\n";
>
> $stmt = $db->query("select * from {$tablename}");
> $res = $stmt->fetch( PDO::FETCH_BOTH );
> $rows = $res[0];
> echo "Table contents: $rows.\n";
>
> ?>
ok, so I ran the test... and it fails 100% of the tests...
# sudo make test
Build complete.
Don't forget to run 'make test'.
PHP Warning: PHP Startup: Unable to load dynamic library
'modules/gd.so' - modules/gd.so: cannot open shared object file: No such
file or directory in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'modules/gd.so' -
modules/gd.so: cannot open shared object file: No such file or directory
in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'modules/mysql.so' - modules/mysql.so: cannot open shared object file:
No such file or directory in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'modules/mysql.so'
- modules/mysql.so: cannot open shared object file: No such file or
directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'modules/mysqli.so' - modules/mysqli.so: cannot open shared object file:
No such file or directory in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'modules/mysqli.so'
- modules/mysqli.so: cannot open shared object file: No such file or
directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'modules/pdo.so' - modules/pdo.so: cannot open shared object file: No
such file or directory in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'modules/pdo.so' -
modules/pdo.so: cannot open shared object file: No such file or
directory in Unknown on line 0
PHP Warning: Module 'pdo_informix' already loaded in Unknown on line 0
Warning: Module 'pdo_informix' already loaded in Unknown on line 0
/usr/bin/php: symbol lookup error: modules/pdo_informix.so: undefined
symbol: php_pdo_register_driver
PHP Warning: PHP Startup: Unable to load dynamic library
'modules/gd.so' - modules/gd.so: cannot open shared object file: No such
file or directory in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'modules/gd.so' -
modules/gd.so: cannot open shared object file: No such file or directory
in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'modules/mysql.so' - modules/mysql.so: cannot open shared object file:
No such file or directory in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'modules/mysql.so'
- modules/mysql.so: cannot open shared object file: No such file or
directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'modules/mysqli.so' - modules/mysqli.so: cannot open shared object file:
No such file or directory in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'modules/mysqli.so'
- modules/mysqli.so: cannot open shared object file: No such file or
directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'modules/pdo.so' - modules/pdo.so: cannot open shared object file: No
such file or directory in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'modules/pdo.so' -
modules/pdo.so: cannot open shared object file: No such file or
directory in Unknown on line 0
PHP Warning: Module 'pdo_informix' already loaded in Unknown on line 0
Warning: Module 'pdo_informix' already loaded in Unknown on line 0
/usr/bin/php: symbol lookup error: modules/pdo_informix.so: undefined
symbol: php_pdo_register_driver
=====================================================================
PHP : /usr/bin/php
CWD : /home/sstaples/informixpdo/PDO_INFORMIX-1.2.6
Extra dirs :
VALGRIND : Not used
=====================================================================
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
