Bug->Doc #45341 [Opn->Ver]: options for odbc_setoptions() are not documented

Edit report at https://bugs.php.net/bug.php?id=45341&edit=1 ID: 45341 Updated by: cmb@php.net Reported by: amy dot wimmersberger at pacourts dot us -Summary: Sybase ODBC Driver odbc_exec +Summary: options for odbc_setoptions() are not documented -Status: Open +Status: Verified -Type: Bug +Type: Documentation Problem Package: ODBC related Operating System: Windows Server 2003 SP1 PHP Version: 5.2.6 Block user comment: N Private report: N New Comment: > Solution: Use the cursor type parameter in odbc_connect as > SQL_CUR_USE_ODBC That appears to be a viable workaround. Alternatively, the INI directive odbc.default_cursortype could be set, or odbc_setoption() for SQL_CURSOR_TYPE could be called with a supported cursor type. The documentation could be improved in this regard. Previous Comments: ------------------------------------------------------------------------ [2008-08-22 05:59:28] kiran dot joseph at gmail dot com Solution: Use the cursor type parameter in odbc_connect as SQL_CUR_USE_ODBC ------------------------------------------------------------------------ [2008-08-22 05:42:59] kiran dot joseph at gmail dot com Do we have a solution to this problem? I am facing the same problem here. Thanks, Kiran ------------------------------------------------------------------------ [2008-06-23 21:02:46] amy dot wimmersberger at pacourts dot us Description: ------------ Sybase ODBC driver for ASE 15 loaded on Server and connectivity tested. Error message on odbc_exec is "[Sybase][ODBC Driver]Optional feature not implemented, SQL state HYC00 in SQLSetStmtOption." Thank you Reproduce code: --------------- $ds=odbc_connect("WEB_PRD1","myloginname","mypassword"); print_r($ds); //prints resource id# $rq = odbc_exec($ds, 'select * from UserOfficeCounty;'); Expected result: ---------------- I expect $rq to contain rows of user, office and county from the table. Actual result: -------------- Error message on odbc_exec is "[Sybase][ODBC Driver]Optional feature not implemented, SQL state HYC00 in SQLSetStmtOption." ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=45341&edit=1