Page 1 of 1

Oracle connectivity+php

Posted: Sat Nov 17, 2007 5:48 am
by shailesh80
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]


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',
);
$db =DB::connect($dsn,$options);


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]