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:
> >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.].
> >
> >
>|||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:
>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:
>> >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.].
>> >
>> >
>>