#45341 [Com]: Sybase ODBC Driver odbc_exec

 ID:               45341
 Comment by:       kiran dot joseph at gmail dot com
 Reported By:      amy dot wimmersberger at pacourts dot us
 Status:           Open
 Bug Type:         ODBC related
 Operating System: Windows Server 2003 SP1
 PHP Version:      5.2.6
 New Comment:

Solution: Use the cursor type parameter in odbc_connect as
SQL_CUR_USE_ODBC


Previous Comments:
------------------------------------------------------------------------

[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 http://bugs.php.net/?id=45341&edit=1