Oracle provider error

I am using SQL Server 2005 on a 64 bit AMD processor machine using the Oracle 10.0.2.0.2.0 and SELECT OPENQUERY will return results from my Oracle table. When I try to do an UPDATE OPENQUERY I get this error message

Msg 7333, Level 16, State 2, Line 1
Cannot fetch a row using a bookmark from OLE DB provider "OraOLEDB.Oracle" for linked server "ORADB".

the same UPDATE OPENQUERY works on SQL Server 2000 using the Oracle 9 client. The provider is configured with Inprocess turned on. Any help would be appreciated.

Hi,

I once has a problem that I had to give a result back from my stored procedure in oracle although I didn#t actually need to return anything. It was just needed for the provider to do some mapping to "a" resultset. perhps you should try that if you are only about to execute a stored procedure with no return values at all.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Is the behavior the same when you use MSDAORA? Have you checked Oracle's knowledge base? It's also a good idea to install the latest patches for the Oracle client.

From the description of the problem it sounds as the Provider is having a problem fetching a row from the Oracle DBMS specified by the SQL engine by a bookmark. If it worked with Oracle 9/SQL 2k, the cause could be either the SQL engine requesting the row from OLEDB in a different manner or an issue within the OraOLEDB provider. Using MSDAORA instead of OraOLEDB would determine where the issue resides.

HTH,

Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello,

We have the same problem here. I don't have any answer yet...

For info, this is for the 64 bit server. With 32 bit and msdaora everything works perfectly...

Where is the native oracle driver for sqlserver 64 bit entreprise version as said in the doc/promo/site ?

Should we downgrade to 32 bit because the 64 bit can't even work with oracle ?

I hope to find an answer soon...

greetings

|||I had the same problem on my x64 box and resolved it (mostly) by installing the Oracle ODAC (available on the Oracle Technology Network) and a patch (#5043675 available on Metalink) that fixes a bug that causes updates and deletes to fail.

Oracle provider error

I am using SQL Server 2005 on a 64 bit AMD processor machine using the Oracle 10.0.2.0.2.0 and SELECT OPENQUERY will return results from my Oracle table. When I try to do an UPDATE OPENQUERY I get this error message

Msg 7333, Level 16, State 2, Line 1
Cannot fetch a row using a bookmark from OLE DB provider "OraOLEDB.Oracle" for linked server "ORADB".

the same UPDATE OPENQUERY works on SQL Server 2000 using the Oracle 9 client. The provider is configured with Inprocess turned on. Any help would be appreciated.

Hi,

I once has a problem that I had to give a result back from my stored procedure in oracle although I didn#t actually need to return anything. It was just needed for the provider to do some mapping to "a" resultset. perhps you should try that if you are only about to execute a stored procedure with no return values at all.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Is the behavior the same when you use MSDAORA? Have you checked Oracle's knowledge base? It's also a good idea to install the latest patches for the Oracle client.

From the description of the problem it sounds as the Provider is having a problem fetching a row from the Oracle DBMS specified by the SQL engine by a bookmark. If it worked with Oracle 9/SQL 2k, the cause could be either the SQL engine requesting the row from OLEDB in a different manner or an issue within the OraOLEDB provider. Using MSDAORA instead of OraOLEDB would determine where the issue resides.

HTH,

Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello,

We have the same problem here. I don't have any answer yet...

For info, this is for the 64 bit server. With 32 bit and msdaora everything works perfectly...

Where is the native oracle driver for sqlserver 64 bit entreprise version as said in the doc/promo/site ?

Should we downgrade to 32 bit because the 64 bit can't even work with oracle ?

I hope to find an answer soon...

greetings

|||I had the same problem on my x64 box and resolved it (mostly) by installing the Oracle ODAC (available on the Oracle Technology Network) and a patch (#5043675 available on Metalink) that fixes a bug that causes updates and deletes to fail.

Oracle provider error

I am using SQL Server 2005 on a 64 bit AMD processor machine using the Oracle 10.0.2.0.2.0 and SELECT OPENQUERY will return results from my Oracle table. When I try to do an UPDATE OPENQUERY I get this error message

Msg 7333, Level 16, State 2, Line 1
Cannot fetch a row using a bookmark from OLE DB provider "OraOLEDB.Oracle" for linked server "ORADB".

the same UPDATE OPENQUERY works on SQL Server 2000 using the Oracle 9 client. The provider is configured with Inprocess turned on. Any help would be appreciated.

Hi,

I once has a problem that I had to give a result back from my stored procedure in oracle although I didn#t actually need to return anything. It was just needed for the provider to do some mapping to "a" resultset. perhps you should try that if you are only about to execute a stored procedure with no return values at all.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Is the behavior the same when you use MSDAORA? Have you checked Oracle's knowledge base? It's also a good idea to install the latest patches for the Oracle client.

From the description of the problem it sounds as the Provider is having a problem fetching a row from the Oracle DBMS specified by the SQL engine by a bookmark. If it worked with Oracle 9/SQL 2k, the cause could be either the SQL engine requesting the row from OLEDB in a different manner or an issue within the OraOLEDB provider. Using MSDAORA instead of OraOLEDB would determine where the issue resides.

HTH,

Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello,

We have the same problem here. I don't have any answer yet...

For info, this is for the 64 bit server. With 32 bit and msdaora everything works perfectly...

Where is the native oracle driver for sqlserver 64 bit entreprise version as said in the doc/promo/site ?

Should we downgrade to 32 bit because the 64 bit can't even work with oracle ?

I hope to find an answer soon...

greetings

|||I had the same problem on my x64 box and resolved it (mostly) by installing the Oracle ODAC (available on the Oracle Technology Network) and a patch (#5043675 available on Metalink) that fixes a bug that causes updates and deletes to fail.

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

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