Oracle linked Server invalid Book mark error

Hi,
I am connecting oracle through the linked server from SQL server
2000.I am able to access oracle data using OPENQUERY method. But Whenever i
Use a direct quiery say
select count(*) from linkedserver.schema.tableName i receive an error
message like this.
OLE DB provider 'MSDAORA' returned a 'NON-CLUSTERED and NOT INTEGRATED'
index 'TABLE NAME_IX02' with incorrect bookmark ordinal 0.
OLE DB error trace [Non-interface error: OLE/DB provider returned an
invalid bookmark ordinal from the index rowset.].You can get the error if you created the linked server using
the provider options Index As Access Path.
Try removing that option.
-Sue
On Fri, 8 Sep 2006 09:16:01 -0700, Suriya Prakash <Suriya
Prakash@.discussions.microsoft.com> wrote:

>Hi,
> I am connecting oracle through the linked server from SQL server
>2000.I am able to access oracle data using OPENQUERY method. But Whenever i
>Use a direct quiery say
>select count(*) from linkedserver.schema.tableName i receive an error
>message like this.
>OLE DB provider 'MSDAORA' returned a 'NON-CLUSTERED and NOT INTEGRATED'
>index 'TABLE NAME_IX02' with incorrect bookmark ordinal 0.
>OLE DB error trace [Non-interface error: OLE/DB provider returned an
>invalid bookmark ordinal from the index rowset.].
>|||Hi Sue,
When I create a new linked server by removing this option. It
works.
Thanks.
-Suriya
"Sue Hoegemeier" wrote:

> You can get the error if you created the linked server using
> the provider options Index As Access Path.
> Try removing that option.
> -Sue
> On Fri, 8 Sep 2006 09:16:01 -0700, Suriya Prakash <Suriya
> Prakash@.discussions.microsoft.com> wrote:
>
>|||Your welcome - thanks for posting back that it worked!
-Sue
On Mon, 11 Sep 2006 10:12:02 -0700, Suriya Prakash
<SuriyaPrakash@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Sue,
> When I create a new linked server by removing this option. It
>works.
>Thanks.
>-Suriya
>
>"Sue Hoegemeier" wrote:
>