Connection Failure

  • Users are getting an error when using an app to connect to the database. I have tried to research it but I find nothing. Wonder if anyone has seen this?
    unexpected error: connection failure context: transaction rollback source Microsoft OLE DB Provider for SQL Server

  • Would need more information, by the sounds of it, the user is connecting, but then getting an error while something is running and the process they are running is rolling back. Put a profile trace on and see what is being called.

  • I think I may have found the issue. I was also getting an error message that the transaction log could not be found. Upon snooping around the database I saw that auto close was set to TRUE. I have made it FALSE hoping this will clear up these unusual messages

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply