HELP with ODBC Connection
| From: | Daniel | Date: | Fri, 06 Dec 2002 15:19:45 +0000 |
| Subject: | HELP with ODBC Connection | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-127260@lists.php.net to get a copy of this message | ||
Please help. I have a basic scipt:
$connection_id=odbc_connect("$DSN","$user","$pass");
$sql="select * from whatever";
$stmt=odbc_prepare($connection_id,$sql);
$result=odbc_execute($connection_id,$stmt);
this script used to work on RH-7.3 with php-4.1.2
the script will not work anymore when i installed RH-8 using php-4.2.2
the connection IS successful, but when i try anything after that i get this
error:
Warning: SQL error: [unixODBC][IBM][iSeries Access ODBC Driver]Error in host
server data stream., SQL state S1000 in SQLPrepare
i can connect,prepare and execute statements from c++ so it must be php
specific?
please help!!