ERROR [40001] [Microsoft][ODBC Driver 11 for SQL Server

We’re getting these two errors during data exports.  I cannot put my finger on any one thing that’s causing it.  I can limit the amount of data and export manually in smaller batches but it still errors from time to time on smaller batches.  After some time passes it starts working as planned.  I don't think this is a FH issue but we don't see related problems anywhere else.  Can you point me in the right direction to figure what’s happening?

Hi CD,

DEADLOCKS are occurs in some special cases. I suppose during your MS SQL Server data export the database is used in parallel from ono or more other applications and a lot of transactions for updates are used herewith?

Currently the only way to suppress database DEADLOCKS for such cases is to run your mass data export in a time window with less database activity.

Preview to the next version) with the current Beta “Version 4.2.1.1 Beta2” (see download links below) I´ve implemented a feature that allows you to set the SQL Server “TRANSACTION ISOLATION LEVEL”.

There are two ways to do this.

1. In the SQL Server Adapter  configuration dialog on “Advanced” tab you can choose the desired “Transaction Isolation Level”, in your case you have to use “READ UNCOMMITTED”.
   
   
2. In the ODBC Adapter , or all other database Adapters, you can put user defined SQL Statements into the “PrepareConnectionSQL” property. In your case you have to use “SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED”.

This setting should prevent your DEADLOCKS in any case.

Beta Version Download
FlowHeater Beta 32 Bit
FlowHeater Beta 64 Bit
FlowHeater Server Beta


MS SQL Server TRANSACTION ISOLATION LEVEL


Prepare Connection SQL Statements

Hey Robert, thanks for the response.  Not sure but, we think we may have discovered the problem, an old IP in an active directory referenced on a domain controller no long around.  In reference to the Adapters,ODBCAdapter and SqlServerAdapter I’ve been using the ODBC adapter.  Other then the obvious connection and the changes you’re working on are there any advantages for one or the other?
 
As always thanks for your help, JD