Page 1 of 1

InterBase & PHP

Posted: Mon Feb 10, 2003 9:59 am
by chharlie2002
Hi to every body.
Im trying to retrieve data from am interbase database.
I can connect succesfully with the database, but when I
attemp to make a query, I receive the follow error:

PHP Warning: InterBase: Dynamic SQL Error SQL error code = -901 feature is not supported in d:\inetpub\wwwroot\intrantex\ibase.php on line 4

Im working PHP 4.3.2 & InterBase 6.0.1 on a IIS 5.
Any help is much appreciated !!!
The script code is this (Sorry my bad English :oops: ):

<?php
$dbh = ibase_pconnect($host, $username, $password,'ISO8859_1', '100', '1' );

$stmt = "SELECT * FROM ACOMP";
$sth = ibase_query($dbh, $stmt);

.......

ibase_free_result($sth);
ibase_close($dbh);
?>

Posted: Mon Feb 10, 2003 11:18 am
by Stoker
php 4.3.2, pre/alpha/beta release? that's invitation to "funny" behaviours..

I havent used Interbase for ages, but is the table name 'ACOMP' in all uppercase letters? try spell it in the same case.. it shouldnt give that error anyway..

hmm.. looks like you are passing buffer and dialect parameters as strings, should be integers according to the manual, doesnt hurt to try this conection line instead:

$dbh = ibase_pconnect($host, $username, $password,'ISO8859_1', 100, 1 );

perhaps it may be caused by the interbase client libs used with PHP is not the same as the server version?