RE: [PHP-DB] Interbase 5.6 error and php 4.0.4

It looks like a dialect problem. I had this when I ran IBv6 as the client machine connecting to IBv5.6 server. The ibase_connect combination that worked was: $dbh = ibase_connect ( $host, $username, $password, 'ISO8859_1', 100, 1 ) ; The three last being the character map, buffers, and dialect. Another way around it is to upgrade the IBv5.6 machine to IBv6. But in our situation, that wasn't possible. Anthony -----Original Message----- From: Greg Kelley [mailto:gkelley@londavia.com] Sent: Wednesday, January 03, 2001 4:44 AM To: php-db@lists.php.net Subject: [PHP-DB] Interbase 5.6 error and php 4.0.4 I just upgraded to 4.0.4 from 4.0.2 and decided to try to access our Interbase Server data. Here is the code snippet: (I had not tried to access Interbase before the upgrade, so I don't know if 4.0.2 was working) <? require("qc.inc"); $conn = ibase_connect($host,$user,$pwd); echo $conn; $sql = "select * from manufacturer"; $rslt = ibase_query($conn,$sql); $rcd = ibase_fetch_object($rslt); echo $rcd->AIRWAY_BILL; ?> qc.inc has our host, user, and pwd info. The result of $conn is 'Resource id #1' which seems to be a strange link id - I thought it was an integer value? The error is Warning: InterBase: Dynamic SQL Error SQL error code = -901 feature is not supported from the $rslt= line where the actual query is run. Any ideas regarding Interbase would be appreciated - thanks. ________________________ Greg Kelley, IT Director Londavia, Inc. Pease Int'l Tradeport 68 New Hampshire Ave. Portsmouth, NH 03801 603.766.3005 http://www.londavia.com SSA, EAA, AOPA, N5506M