I am trying to write from a sql database on one server to another sql database on another server. The first feature writer works fine but I am getting an error message
"Microsoft SQL Server Non-Spatial Writer: Failed to start database transaction. Provider error `(-2147168237) Cannot start more transactions on this session.'
A fatal error has occurred. Check the logfile above for details"
with the when the second feature writer tries to write.
+2
SQL Server ADO does not allow multiple transactions in a session. I'm surprised you are seeing this if you are writing to two separate database servers. Perhaps they are separate databases on the same SQL Server.
You might try using the SQL Server JDBC writer instead: Microsoft SQL Server Non-Spatial (JDBC)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.