I'm getting this error and I'm not sure how to trouble shoot. I have BTS 2002 getting data from SQL Server on a separate machine. I tested my connection with Windows authentication on my job successfully but for some reason get this error. Can anyone help?
* *
Event Type: Error
Event Source: RFSQL
Event Category: None
Event ID: 10
Date: 10/8/2003
Time: 6:42:48 AM
User: N/A
Computer: BTS1
Description:
A worker thread reported a failure: [OLE/DB provider returned message: Neither the isolation level nor a strengthening of it is supported.]
The error code is shown in the data area below.
The operation was: ISQLWorker->Execute
The worker thread was working on:
 Job Name: LateShipmentJob
 SQL Script: select distinct (number), cust, status
from mytable1
where status <> 'D' for xml auto

Error code: 80004005

**
thanks,
Phil
**

__________________
**
thanks,
Phil
**

I've determined that the issue may be with the query in BizTalk trying to extract a result set from a view that is set up via a linked server in SQL Server 2000 to a FoxPro Database.

I am also not able to set the job up using a stored procedure. An error tells me that "Streaming not supported over multiple column result."

I'm still not sure what's wrong exactly.

**
thanks,
Phil
**

Hi,

I get the same error with BTS (Win2k3) & SQL server (W2k) on a separate machine
It's look like a security/identity problem

Did find the solution ?

Thanks
Eric

I resolved it by setting the isolation level. My view is created using a linked server. Some of the data I get is on a FoxPro db. However, I still get an ODBC error related to FoxPro.

hth! - Phil

CREATE PROCEDURE sp_spname
AS

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

BEGIN TRANSACTION

SELECT distinct (idnumber), city , st, cdate, ctime
FROM vw_myView
WHERE status = 'Y'
AND cdate > GETDATE()-2 for xml auto

COMMIT TRANSACTION
GO