Heterogeneous queries and use of OLEDB providers are not supported

Hi all
I am trying to create linked server on 2005 64bit server for 2000 32 bit.
I ran instcat.sql script as microsoft article sugested.
Still, I am having problems.
I can browse db objects using management studio.
But when i try to run sql like:
select count(*) from botserver.master.dbo.sysobjects
I am getting:
Heterogeneous queries and use of OLEDB providers are not supported in fiber
mode.
I can neither run any stored procs.
My linked server is defined as server type: sql server
Any ideas?Why are you running in fiber mode in the first place? Unless you have a
very good reason for turning it on you should turn it back off and solve two
problems.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:DE0360F5-3A4C-47BB-9304-10D0FA789855@.microsoft.com...
> Hi all
> I am trying to create linked server on 2005 64bit server for 2000 32 bit.
> I ran instcat.sql script as microsoft article sugested.
> Still, I am having problems.
> I can browse db objects using management studio.
> But when i try to run sql like:
> select count(*) from botserver.master.dbo.sysobjects
> I am getting:
> Heterogeneous queries and use of OLEDB providers are not supported in
> fiber
> mode.
> I can neither run any stored procs.
> My linked server is defined as server type: sql server
> Any ideas?