Skip to main content
  • EN

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.

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)

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.