Oracle connectivity+php

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
shailesh80
Forum Newbie
Posts: 1
Joined: Sat Nov 17, 2007 5:38 am

Oracle connectivity+php

Post 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]
Post Reply