How to Transaction Insert in C3 Sql server

Posted by Jayakumars under ASP.NET on 10/29/2013 | Points: 10 | Views : 898 | Status : [Member] [MVP] | Replies : 3
hi

i try to insert like this

using (System.Transactions.TransactionScope trans = new System.Transactions.TransactionScope())
{
}

i face this error how to solve this? i change MSDTDC setup also and restart my pc but
this issue did not solve how to solve this?

The partner transaction manager has disabled its support for remote/network transactions.
(Exception from HRESULT: 0x8004D025)

Mark as Answer if its helpful to you


Responses

Posted by: Bandi on: 10/29/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Fix for the above error:
First verify the "Distribute Transaction Coordinator" Service is
running on both database server computer and client computers
1. Go to "Administrative Tools > Services"
2. Turn on the "Distribute Transaction Coordinator" Service if it is not running

If it is running and client application is not on the same computer as
the database server, on the computer running database server
1. Go to "Administrative Tools > Component Services"
2. On the left navigation tree, go to "Component Services > Computers
> My Computer" (you may need to double click and wait as some nodes
need time to expand)
3. Right click on "My Computer", select "Properties"
4. Select "MSDTC" tab
5. Click "Security Configuration"
6. Make sure you check "Network DTC Access", "Allow Remote Client",
"Allow Inbound/Outbound", "Enable TIP" (Some option may not be
necessary, have a try to get your configuration)
7. The service will restart
8. BUT YOU MAY NEED TO REBOOT YOUR SERVER IF IT STILL DOESN'T WORK
(This is the thing drove me crazy before)

On your client computer use the same above procedure to open the
"Security Configuration" setting, make sure you check "Network DTC
Access", "Allow Inbound/Outbound" option, restart service and computer
if necessary.

On you SQL server service manager, click "Service" dropdown, select
"Distribute Transaction Coordinator", it should be also running on
your server computer.

Hope it helps,


Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 10/29/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer
http://stackoverflow.com/questions/4829688/c-sql-execute-multiple-insert-update-in-one-transaction
http://go4answers.webhost4life.com/Example/partner-transaction-manager-disabled-74718.aspx


EDIT:
http://www.vbforums.com/showthread.php?584326-RESOLVED-Transaction-Scoop-Generate-Error

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 10/29/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
http://www.windows-tech.info/13/5b06f47f53e163fe.php

For detailed description on TransactionScope in SQL Compact
http://technet.microsoft.com/en-us/library/bb896149.aspx

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response