The Transaction Must Be Disposed Before The Connection Can Be Used To Execute Sql Statements

I am getting this error The transaction must be disposed before the connection can be used to execute sql statements. i have an Excel file that contains about 6000 rows and I up

Solution 1:

I solved it by adding the below lines in App.config:

<configuration><system.transactions><defaultSettingstimeout="00:01:30" /></system.transactions></configuration>

and this in Machine.config:

<configuration><system.transactions><machineSettingsmaxTimeout="00:01:30" /></system.transactions></configuration>

As this process takes a very long time greater than 10 minutes, so I found that I need to overwrite this value with a higher one.