Exception with bulk insert with remote sql server

Question

I am calling a rest full service which in turn performs bulk insert in sql server database. Every thing works fine when rest server and the database server are on same machine, but in case of remote database sever following exception is encoutered.

System.InvalidOperationException: The transaction associated with the current 
connection has completed but has not been disposed.
The transaction must be disposed before the connection can be used to
execute SQL statements.

I am using following transactions.

TransactionOptions tOptions = new TransactionOptions();
tOptions.IsolationLevel = IsolationLevel.ReadCommitted;
//This transaction is required here as it checks for all db operations.
using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, tOptions))
{
    //DB operations....
    transactionScope.Complete();
}

I tried transationScope.Dispose() after transactionScope.Complete() but that didnt work. — Rajat Saini
– Rajat Saini, Commented Sep 13, 2012 at 5:36

Rajat Saini · Accepted Answer · 2012-09-14 04:25:29Z

1

Configuring the windows MSDTC service on my IIS server did the trick.

The following link shows how to configure MSDTC.

http://www.deepakkapoor.net/turn-on-msdtc-windows-7/

answered Sep 14, 2012 at 4:25

Rajat Saini

5577 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exception with bulk insert with remote sql server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related