Error: Cannot fetch the rowset from OLE DB provider "SQLNCLI" for linked server "

Hi,

I′m trying to make several distributed queries to a linked server, and for some of them I get this error message. I can′t find anytihing about it anywhere. Can anyone tell me what could be the reason of this error? The way I'm executing the query in my stored procedure is:

exec sp_executesql @.sqlinsert

@.sqlinsert being a nvarchar sentence that contains the distibuted query.

Thank you!

Mehdi

Guess the provider needs a return value. I don′t know if it needs a return status like return 1 or return 0, or he needs something to handle (just a dummy select or something else. Try setting the return value for the stored procedure.

HTH, Jens Suessmeyer.

error: Attempt to fetch logical page

Hi,
During an upgrade from sql server 6.5 to sql server 2000 I receive the
follwoing error and the upgrade process remains stuck until terminated
manually:
ODBC error 605 (HY000) Attempt to fetch logical page 1430280 in database
'nice_cls' belongs to object 'NICE_CLS_CALLS_0008', not to object
'NICE_CLS_CALLS_0007'.
I tried using dbcc checkdb and received the same error.
Is there any idea how to address this situation or how to delete the
specific page?
Thanks,
YanivHi Yaniv,
This error occurs when Microsoft SQL Server detects database corruption.
The second object specified in the text not to object '%.*ls' is probably
corrupt. Because this error can mask the existence of other errors, execute
DBCC CHECKDB to determine the extent of the damage.
I am assuming that the corruption is happening on your SQL Server 6.5
server. The best way to recover from corruption is to restore from your
good backup.
I hope this helps !!!
Thanks,
Fargham
Microsoft - SQL Server

error: Attempt to fetch logical page

Hi,
During an upgrade from sql server 6.5 to sql server 2000 I receive the
follwoing error and the upgrade process remains stuck until terminated
manually:
ODBC error 605 (HY000) Attempt to fetch logical page 1430280 in database
'nice_cls' belongs to object 'NICE_CLS_CALLS_0008', not to object
'NICE_CLS_CALLS_0007'.
I tried using dbcc checkdb and received the same error.
Is there any idea how to address this situation or how to delete the
specific page?
Thanks,
YanivHi Yaniv,
This error occurs when Microsoft® SQL Server detects database corruption.
The second object specified in the text not to object '%.*ls' is probably
corrupt. Because this error can mask the existence of other errors, execute
DBCC CHECKDB to determine the extent of the damage.
I am assuming that the corruption is happening on your SQL Server 6.5
server. The best way to recover from corruption is to restore from your
good backup.
I hope this helps !!!
Thanks,
Fargham
Microsoft - SQL Server

error: Attempt to fetch logical page

Hi,
During an upgrade from sql server 6.5 to sql server 2000 I receive the
follwoing error and the upgrade process remains stuck until terminated
manually:
ODBC error 605 (HY000) Attempt to fetch logical page 1430280 in database
'nice_cls' belongs to object 'NICE_CLS_CALLS_0008', not to object
'NICE_CLS_CALLS_0007'.
I tried using dbcc checkdb and received the same error.
Is there any idea how to address this situation or how to delete the
specific page?
Thanks,
Yaniv
Hi Yaniv,
This error occurs when Microsoft SQL Server detects database corruption.
The second object specified in the text not to object '%.*ls' is probably
corrupt. Because this error can mask the existence of other errors, execute
DBCC CHECKDB to determine the extent of the damage.
I am assuming that the corruption is happening on your SQL Server 6.5
server. The best way to recover from corruption is to restore from your
good backup.
I hope this helps !!!
Thanks,
Fargham
Microsoft - SQL Server