php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #835 Problems with Openlink / Prepared Statements
Submitted: 1998-10-08 18:45 UTC Modified: 1999-07-11 04:35 UTC
From: bleyton at cpe-corp dot com Assigned: kara (profile)
Status: Closed Package: ODBC related
PHP Version: 3.0.5 OS: AIX 4.2.1
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: bleyton at cpe-corp dot com
New email:
PHP Version: OS:

 

 [1998-10-08 18:45 UTC] bleyton at cpe-corp dot com
I've been having some trouble with the Openlink ODBC drivers & PHP.  I've
been working with Openlink to resolve the problems for quite some time, and
I finally got them to look at it in detail.  Unfortunately, they're pointing
the finger back at PHP, and I don't understand this stuff in enough detail
to know if there  is anything that can be done within PHP to fix it.

In a nutshell, there are 2 issues.  The first issue is that when I use
odbc_num_rows, it works fine for a directly executed statement, but fails
when using prepared statements.

#2 is similar - when I use odbc_fetch_row and I specify the row number that
I want to fetch, it works fine for a directly executed statement, but fails
when using prepared statements.

I ran some tests, and forwarded all of the debug messages to Openlink, and
here's what I got back from them:

>I believe what's happening here is that you / PHP have not set any
concurrency
>nor a rowset size prior to calling SQLExtendedFetch(). This is possibly due
to
>the fact that PHP is requesting a dynamic cursor, whereas we implement a
KSD
>cursor (keyset-driven) instead - note the SQL_SUCCESS_WITH_INFO return
state of
>SQLSetStmtOption(6,2), which is the call to go into dynamic mode. If PHP is
>ignoring this return state, it could be assuming that it doesn't need to
set
>concurrency or rowset sizes.

>Is there anything you can do in PHP to fix this?

BTW, my preference is to directly execute statements rather than use
prepared statements, however Openlink has some unresolved issues with the
way escaped quotes are handled with directly executed statements, so I
basically have no choice.

Environment is AIX 4.2.1, Openlink is the latest version from their website.  I've also compiled in MySQL support.  PHP is version 3.0.5 running as an Apache module (1.3.0).  Database is Progress version 7.3E. 

Thanks in advance for your help.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-07-11 04:35 UTC] kara at cvs dot php dot net
Reverted to simpler functions as of PHP 3.0.10 which should 
solve these problems but disables absolute fetching of results.

 
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Mon Jan 27 12:01:24 2020 UTC