After SQL 2005 SP2, Query to Apartment Linked Servers fails

We have a linked server that is an Apartment model OLE DB Provider. It works fine on SQL 2005 SP1. After applying SP2, we get the following msg when running a query against the linked server. I cannot find anything in the SP2 doc that indicates a change of behavior for linked servers. Any ideas ?

Bill

Msg 7308, Level 16, State 1, Line 1

OLE DB provider 'DBAmp.DBAmp' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

We are having exact same problem

Msg 7308, Level 16, State 1, Line 1

OLE DB provider 'xxxx.xxxxxx' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

Does anyone have any idea on how to solve this ?

toby

|||

Same here.

Worked fine in SQL Server 2000 (any service pack) and SQL Server 2005 (including SP1) but broke in 2005 with SP2.

Any clues?

Many thanks|||

I confirmed with forceamp support that something in SP2 causes this failure in DBAmp. You need to download the v2.6 beta to resolve this issue or contact support@.forceamp.com and to determine the right build to resolve this issue.

Chad