Greetings all:

Using: RH6.2, Apache 1.3.17, PHP4.0.4pl1, IBMdb2 V7.1, & PostgreSQL 7.03

PHP statically linked to Apache.

Postgres, php, & Apache all working well together.

Have made the appropriate symlinks for db2 & Apache (libdb2.so.1, etc)

db2 works fine from the command line or from within >>db2

However, when using the following script:

<html> stuff here.....
<?php
        $conn=odbc_connect("sample","db2inst1","ibmdb2");
        $query="Select lastname from employee where firstnme='JASON'";
        $result=odbc_exec($conn, $query);

        echo $result;    [Only one value should be returned, GOUNOT]

        odbc_close($conn);
?>
</html>

I get this error:  Warning SQL error, SQL state y[ASCII hex 98]P[ASCII
hex 50] SQLConnect in ../../test.php line 5

Using odbc_pconnect produces a similar error message but longer with
many more "garbage" characters for a message!

Any ideas as to what's going on & how to fix it would be most
appreciated.

....tnx.....


....bill sneed, prospect, maine....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The level which science has reached is determined by how far it is
capable of a crisis in its basic concepts.  M. Heidegger, S & Z


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to