Bug #36435 [Com]: Executing SQL directly; no cursor error

Edit report at https://bugs.php.net/bug.php?id=36435&edit=1 ID: 36435 Comment by: MATHESHWARAN at IN dot COM Reported by: rvest at policytech dot com Summary: Executing SQL directly; no cursor error Status: No Feedback Type: Bug Package: ODBC related Operating System: Windows XP Professional PHP Version: 5.1.2 Block user comment: N Private report: N New Comment: cHECK THE ACCESS FOR THAT PERTICULAR DATABASE AND SERVER WITH THE uSER WHICH YOU LOGGED INT. Previous Comments: ------------------------------------------------------------------------ [2008-08-13 12:58:28] phpbug at tab1 dot clara dot co dot uk I still get this error with 5.2.6 Adding SQL_CUR_USE_ODBC as the last parameter to odbc_connect seems to cure it, not sure if there are drawbacks to using that option though. ------------------------------------------------------------------------ [2007-07-31 01:00:00] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2007-07-23 12:07:59] jani@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi And try this with the PDO ODBC driver instead. ------------------------------------------------------------------------ [2006-08-04 12:16:42] markvt at home dot nl This error occurs when your query is not correct. ------------------------------------------------------------------------ [2006-02-17 23:08:50] rvest at policytech dot com Description: ------------ I ran a query against a Microsoft SQL Server 2005 through ODBC. It is a DNSless connection using the Native Client for Microsoft SQL Server 2005. I am using the SQL_CUR_USE_DRIVER cursor in the odbc_pconnect function. I get the error "Executing SQL directly; no cursor." when using the odbc_exec function. Actual result: -------------- [17-Feb-2006 14:18:19] VERSION: 4.000.5 REFERER: http://localhost/Content_Redirect.php?Section=Home SCRIPT_NAME: /c_Home/index.php SCRIPT_FILENAME: C:\vestws\bin\c_Home\index.php ERROR NUMBER: 1024 BROWSER: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 2.0.50727) System: Windows NT REBECCA 5.1 build 2600 FILE: C:\vestws\bin\includes\inc_db.php LINE: 1533 ERROR: [Microsoft][SQL Native Client][SQL Server]Executing SQL directly; no cursor. BACKTRACE: --------------------- #0 errHand(1024, [Microsoft][SQL Native Client][SQL Server]Executing SQL directly; no cursor., C:\vestws\bin\includes\inc_db.php, 1533, Array ([type] => 97,[msg] => [Microsoft][SQL Native Client][SQL Server]Executing SQL directly; no cursor.,[ex] => DBException Object ([] => Array ([dbHost] => rebecca\sqlexpress,[dbType] => 2005_mssql,[dbName] => wksp4_0,[dbUsername] => sa,[dbPass] => imagin,[dbPort] => 3268,[dbFilename] => ,[mysql_usetransactions] => ,[use16BitChars] => ),[] => [Microsoft][SQL Native Client][SQL Server]Executing SQL directly; no cursor.,[] => Resource id #24,[] => 97,[] => [Microsoft][SQL Native Client][SQL Server]Executing SQL directly; no cursor.,[] => ,[] => 97,[] => C:\vestws\bin\includes\inc_db.php,[] => 1527,[] => Array ([0] => Array ([file] => C:\vestws\bin\includes\inc_db.php,[line] => 439,[function] => throwError,[class] => DB,[type] => ->,[args] => Array ([0] => 97,[1] => [Microsoft][SQL Native Client][SQL Server]Executing SQL directly; no cursor.)),[1] => Array ([file] => C:\vestws\bin\includes\inc_db.php,[line] => 226,[function] => _Execute,[class] => DB,[type] => ->,[args] => Array ([0] => SELECT GroupID, GroupName FROM xUsersPermissions INNER JOIN Groups ON Groups.Group = xUsersPermissions.GroupID AND Groups.GroupName <> '' WHERE PermissionCode = 'dca' AND UserID = 2,[1] => )),[2] => Array ([file] => C:\vestws\bin\c_home\index.php,[line] => 40,[function] => Execute,[class] => DB,[type] => ->,[args] => Array ([0] => SELECT GroupID, GroupName FROM xUsersPermissions INNER JOIN Groups ON Groups.Group = xUsersPermissions.GroupID AND Groups.GroupName <> '' WHERE PermissionCode = 'dca' AND UserID = 2)))))) called at [(null):0] #1 trigger_error([Microsoft][SQL Native Client][SQL Server]Executing SQL directly; no cursor.) called at [C:\vestws\bin\includes\inc_db.php:1533] #2 DB->throwError(97, [Microsoft][SQL Native Client][SQL Server]Executing SQL directly; no cursor.) called at [C:\vestws\bin\includes\inc_db.php:439] #3 DB->_Execute(SELECT GroupID, GroupName FROM xUsersPermissions INNER JOIN Groups ON Groups.Group = xUsersPermissions.GroupID AND Groups.GroupName <> '' WHERE PermissionCode = 'dca' AND UserID = 2, ) called at [C:\vestws\bin\includes\inc_db.php:226] #4 DB->Execute(SELECT GroupID, GroupName FROM xUsersPermissions INNER JOIN Groups ON Groups.Group = xUsersPermissions.GroupID AND Groups.GroupName <> '' WHERE PermissionCode = 'dca' AND UserID = 2) called at [C:\vestws\bin\c_home\index.php:40] ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=36435&edit=1