Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

RE: [PHP-DB] Interbase 5.6 error and php 4.0.4 From: Anthony Martin (Anthony <email protected>)
Date: 01/04/01

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 <email protected>]
Sent: Wednesday, January 03, 2001 4:44 AM
To: php-db <email protected>
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 

-- 
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>