Req #77917 [Opn->Fbk]: Don't use ODBC cursor library in PDO_ODBC?

From: Date: Thu, 01 Oct 2020 09:38:42 +0000
Subject: Req #77917 [Opn->Fbk]: Don't use ODBC cursor library in PDO_ODBC?
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-229297@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=77917&edit=1

 ID:                 77917
 Updated by:         cmb@php.net
 Reported by:        yatao dot wang at aliyun dot com
 Summary:            Don't use ODBC cursor library in PDO_ODBC?
-Status:             Open
+Status:             Feedback
 Type:               Feature/Change Request
 Package:            PDO ODBC
 Operating System:   Windows
 PHP Version:        master-Git-2019-04-18 (Git)
-Assigned To:        
+Assigned To:        cmb
 Block user comment: N
 Private report:     N

 New Comment:

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?


Previous Comments:
------------------------------------------------------------------------
[2019-04-18 10:12:40] 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?



------------------------------------------------------------------------



--
Edit this bug report at https://bugs.php.net/bug.php?id=77917&edit=1

Thread (3 messages)

« previous php.bugs (#229297) next »