iodbc + php4
| From: | Andrew Smith | Date: | Thu, 27 Jul 2000 01:13:27 +0000 |
| Subject: | iodbc + php4 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1551@lists.php.net to get a copy of this message | ||
Hi All,
Anyone run into intermittent errors like the following?
Warning: SQL error: [iODBC][Driver Manager]Function sequence error, SQL
state S1010 in SQLAllocStmt in /home/sites/site6/web/pingodbc.php on line 10
I've tried the following combinations
php4.0.1pl2 + iodbc 3.0.2
php4.0.1pl2 + iodbc 2.50.3
php4.0.1RC2 + iodbc 3.0.2
php4.0.1RC2 + iodbc 2.50.3
But I get the same problem on all of them. The error occurs more often than
the result set is returned.
All the env vars are present and it successfully connects every time, the
error occurs on the odbc_exec.
Here's my test script for querying any MSSQL DB (since sysobjects is a
system table)
<?
if ($connID = odbc_connect($HTTP_GET_VARS['dsn'],
$HTTP_GET_VARS['usr'],
$HTTP_GET_VARS['pass']))
echo "Connection Established";
else
echo "Connection Failed";
if($HTTP_GET_VARS['query']=='y') {
$res = odbc_exec($connID,"SELECT * FROM sysobjects");
odbc_result_all($res);
}
?>
Anyone come across this?
Andrew