Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Hi
Database: Oracle 9.1
PHP: 5+
I am using microsoft odbc for oracle version: 2.576.1830.00 .Code: Select all
$dsn = "odbc://abc:abc@xyz";
$options = array(
'debug' => 2,
'portability' => DB_PORTABILITY_ALL,
"optimize" => 'portability',
);I am not able to use count, max function in my sql query.
Error is [message] => DB Error: DB backend not capable [userinfo] => select count(user_ID) as cnt from users_T [nativecode=S1C00 [Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct clause, union, intersect or minus or on read only result set]
Thanks in advance
feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]