|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-01-23 10:51 UTC] sniper@php.net
[2006-01-25 17:08 UTC] michael at bluemoon dot com
[2006-04-09 07:48 UTC] wez@php.net
[2007-10-30 22:35 UTC] lwe@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 07:00:01 2025 UTC |
Description: ------------ Exception thrown when issuing SELECT query using PDO driver for Firebird/Interbase. Database Server runs Interbase 7.5.x (Linux). Problem occurs with PHP 5.1.2 running in both Linux/Apache 2 and Windows 2000/IIS environments. Tried running PHP alternately with Interbase 6 and 7.5 Run- time Client Libraries on each platform; same problem. Native PHP Firebird/Interbase functions (e.g., ibase_connect (), etc.) functions work fine in same environments used to test PDO functions. Confirmed DSN string used in my PDO connection function is correct by testing PDO::ATTR_CONNECTION_STATUS attribute; value returned is 1. Reproduce code: --------------- try { $dbh = new PDO($dsn, $user, $password, array( PDO::ATTR_PERSISTENT => true )); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $dbh->prepare("SELECT Count(*) FROM MY_TABLE"); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_NUM); $stmt = null; echo $row[0]; } catch (PDOException $e) { die $e->getMessage(); } Expected result: ---------------- Should output integer value result from SELECT query to screen Actual result: -------------- Outputs the following error: SQLSTATE[HY000]: General error: -804 Dynamic SQL Error SQL error code = -804 Incorrect values within SQLDA structure