ID: 36435 Comment by: markvt at home dot nl Reported By: rvest at policytech dot com Status: Open Bug Type: ODBC related Operating System: Windows XP Professional PHP Version: 5.1.2 New Comment:
This error occurs when your query is not correct. Previous Comments: ------------------------------------------------------------------------ [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 http://bugs.php.net/?id=36435&edit=1
