Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

[PHP-DB] interbase -901 - feature not supported / connect string problem? From: Test1 (test <email protected>)
Date: 12/13/00

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) 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>