InterBase & PHP

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
chharlie2002
Forum Newbie
Posts: 1
Joined: Mon Feb 10, 2003 9:59 am
Contact:

InterBase & PHP

Post 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);
?>
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post 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?
Post Reply