interbase -901 - feature not supported / connect string problem?
| From: | Test1 | Date: | Wed, 13 Dec 2000 17:54:37 +0000 |
| Subject: | interbase -901 - feature not supported / connect string problem? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5215@lists.php.net to get a copy of this message | ||
I'm using PHP 4.03, Window NT. PHP and IB are running on two different
machines.
Connection to the IB Server is fine using other IB clients and ODBC. PHP
ODBC works fine. With PHP interbase extension, I get th following error
(even from php.exe at the command line):
Interbase: Dynamic SQL error code = -901 feature is not supported
This happens *after* the connect when I try a simple select from a small
table. IB can return this error when the client passes a bad connection
string. Here's the code:
<?php
$host = "192.168.0.2:F:\\DATA\\DATA.GDB";
$username = "SYSDBA";
$password = "masterkey";
$dbh = ibase_connect ($host, $username, $password);
$stmt = "SELECT NAME FROM S_USERS";
$sth = ibase_query ($dbh, $stmt); <<<<<<< error is here
while ($row = ibase_fetch_object ($sth)) {
print $row->NAME . "\n";
}
ibase_close ($dbh);
?>
Any ideas?
Thanks
-Dave Lewicki
dlewicki @ free case.com (remove spaces)