php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #1245 odbc_exec fails, odbc_prepare/odbc_execute work
Submitted: 1999-03-18 02:24 UTC Modified: 1999-07-11 04:36 UTC
From: andrew dot macintyre at aba dot gov dot au Assigned:
Status: Closed Package: ODBC related
PHP Version: 3.0.6 OS: FreeBSD 2.2.7-Release
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: andrew dot macintyre at aba dot gov dot au
New email:
PHP Version: OS:

 

 [1999-03-18 02:24 UTC] andrew dot macintyre at aba dot gov dot au 
Apache-1.3.4+PHP-3.0.6 port taken from FreeBSD ports, modified to configure with "-with-openlink".  Openlink MT driver library (BSDI 2.1version) statically linked without the iODBC driver manager.  RDBMS server is Ingres 6.4(05).  PHP also configure with PostgreSQL and the font support.

Having successfully connected to the Ingres database & successfully issued a "set lockmode ...." statement using odbc_exec(), issuing a simple select of the form "select key, value from table" via:

1) odbc_exec() - fails with "Syntax error or access violation" [ODBC state 37000].

2) odbc_prepare()/odbc_execute() - works correctly.

To confirm, I built the test program from the iODBC v2.50 driver manager suite, and linked in the Openlink driver the same way as for PHP, and the same select was issued and returned the correct result, ie the same as the result obtained from the _prepare/_execute sequence above.

I note from bug #835 that there are/were differences in behaviour between the two SQL execution techniques when the Openlink drivers are involved.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-07-11 04:36 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-2024 The PHP Group
All rights reserved. 		Last updated: Fri Apr 26 01:01:30 2024 UTC