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

go to bug id or search bugs for

Request #77917 Don't use ODBC cursor library in PDO_ODBC?
Submitted: 2019-04-18 10:12 UTC Modified: 2020-10-11 04:22 UTC
From: yatao dot wang at aliyun dot com Assigned: cmb (profile)
Status: No Feedback Package: PDO ODBC
PHP Version: master-Git-2019-04-18 (Git) OS: Windows
Private report: No CVE-ID: None
View Developer Edit
 [2019-04-18 10:12 UTC] yatao dot wang at aliyun dot com 
Description:
------------
I have an ODBC driver which only supports the FORWARD_ONLY cursor.
So it will return an error in SQLGetData.
<
[SL008] [Microsoft][ODBC Cursor Library] SQLGetData is not allowed on a forward-only (non-buffered) cursor (0)
>

Can it add an option for PDO ODBC so that it can use the driver's cursor rather than ODBC cursor library? Or use driver's cursor as default?

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2020-10-01 09:38 UTC] cmb@php.net
-Status: Open +Status: Feedback -Assigned To: +Assigned To: cmb
 [2020-10-01 09:38 UTC] cmb@php.net 
There is already the yet undocumented driver specific option
PDO::ODBC_ATTR_USE_CURSOR_LIBRARY.  You can set it to
ODBC_SQL_USE_DRIVER to never use the ODBC cursor library. Does
that solve the problem, or are there still issues with the
SQLGetData() calls?
 [2020-10-11 04:22 UTC] php-bugs at lists dot php dot net 
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Re-Opened". Thank you.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 14:01:32 2024 UTC