#25505 [Com]: SQLExtendedFetch() vs SQLFetch()

ID: 25505 Comment by: moreinfo at potentialtech dot com Reported By: michaelc at mikeit dot com dot au Status: No Feedback Bug Type: ODBC related Operating System: Win32 PHP Version: 4.3.3 New Comment: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlextendedfetch.asp The problem I am seeing is that SQLExtendedFetch is Deprecated. It has been replaced by SQLFetchScroll. Only newer ODBC drivers which are not backwards compatible will fail. The unified ODBC driver is using this deprecated ODBC Standard by default in the win32 version of php. Workarounds exist, but this problem may become more common with time. Previous Comments: ------------------------------------------------------------------------ [2003-09-22 06:46:59] sniper@php.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 "Open". Thank you. ------------------------------------------------------------------------ [2003-09-16 08:39:26] kalowsky@php.net Not that I know of. It will require a recompile to insert this change. ------------------------------------------------------------------------ [2003-09-16 00:39:12] michaelc at mikeit dot com dot au Will the windows version heed windows system variables ? Will try the next time I boot across to win32. ------------------------------------------------------------------------ [2003-09-11 23:30:06] kalowsky@php.net Following ODBC spec's ExtendedFetch is required for API conformance Level2, the minimum PHP supports (I believe). You should probably contact the MYOB people and inform them to use a fully compliant ODBC driver, such as the Microsoft one. That being said you can also just set HAVE_SQL_EXTENDED_FETCH to 0 and life should be golden for you to bypass this. ------------------------------------------------------------------------ [2003-09-11 22:23:13] sniper@php.net What would '(gdb) bt' (bt, as in backtrace) output? That small part of it looks more like the MYOB crashes rather than PHP.. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/25505 -- Edit this bug report at http://bugs.php.net/?id=25505&edit=1