I am getting following error message when I tried to add a user in my list.
The way I have it designed it, I have sql database which connects to another sql database using a link server and .Net webform. I am using web form to entered the new user and it goes to the database. I have insert trigger on my first database and as soon as new entry happens it should fire insert trigger and add the data to the another database which is on different server but I have linked that server to my first sql server.
Expand|Select|Wrap|Line Numbers
- Server Error in '/Tap/TapManager' Application.
- --------------------------------------------------------------------------------
- Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACT_ABORT option was set to OFF. INSIDE WHILE COMPARE [OLE/DB provider returned message: Cannot start more transactions on this session.] OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionLocal::StartTransaction returned 0x8004d013: ISOLEVEL=4096].
- Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
- Exception Details: System.Data.SqlClient.SqlException: Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACT_ABORT option was set to OFF. INSIDE WHILE COMPARE [OLE/DB provider returned message: Cannot start more transactions on this session.] OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionLocal::StartTransaction returned 0x8004d013: ISOLEVEL=4096].
- Source Error:
- Line 125: //dbAccess1.sqlDataAdapterSD_CO_NU.InsertCommand.Parameters["@SYNCREP_RSS_LAST_UPDATE"].Value = DateTime.Now;
- Line 126: dbAccess1.sqlDataAdapterSD_CO_NU.InsertCommand.Connection.Open();
- Line 127: dbAccess1.sqlDataAdapterSD_CO_NU.InsertCommand.ExecuteNonQuery();
- Line 128: dbAccess1.sqlDataAdapterSD_CO_NU.InsertCommand.Connection.Close();
- Line 129: