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

go to bug id or search bugs for

Doc Bug #45341 options for odbc_setoptions() are not documented
Submitted: 2008-06-23 21:02 UTC Modified: 2020-10-05 08:44 UTC
Votes:2
Avg. Score:4.0 ± 1.0
Reproduced:2 of 2 (100.0%)
Same Version:2 (100.0%)
Same OS:1 (50.0%)
From: amy dot wimmersberger at pacourts dot us Assigned:
Status: Verified Package: ODBC related
PHP Version: 5.2.6 OS: Windows Server 2003 SP1
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: amy dot wimmersberger at pacourts dot us
New email:
PHP Version: OS:

 

 [2008-06-23 21:02 UTC] 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."

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2008-08-22 05:42 UTC] 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-08-22 05:59 UTC] kiran dot joseph at gmail dot com 
Solution: Use the cursor type parameter in odbc_connect as SQL_CUR_USE_ODBC
 [2020-10-05 08:44 UTC] cmb@php.net
-Summary: Sybase ODBC Driver odbc_exec +Summary: options for odbc_setoptions() are not documented -Status: Open +Status: Verified -Type: Bug +Type: Documentation Problem
 [2020-10-05 08:44 UTC] cmb@php.net 
> 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.
 [2020-10-05 08:45 UTC] cmb@php.net 
Related To: Bug #52658
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Mon Nov 25 17:01:31 2024 UTC