Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Connection Property of a distributed is being set to nothing, when I call SqlCommand.ExecuteReader Expand / Collapse
Posted Saturday, March 16, 2013 6:34 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, March 16, 2013 6:35 AM
Points: 533, Visits: 12
Hi ,
I am using distributed transaction, in which I am inserting some date from
Server1.Db1 to Server1.db2, with same database schema.

and similar process in Server2 and server1,
i.e. inserting data From Server2.db3 to Server1.Db2

for the server1.Db1 to Server1.db2 the process is running ok.
but for server2.db3 to server1.db2, it was working earlier, but now when i call SqlCommand.ExecuteReader() at a specific point, the Connection property of the Transaction is being set to nothing, and the transaction rolls back.

it is something like that table has some kind of corruption, but i am able to fire all commands on that table locally.

but not from server2, then it causes problems.

when i drop and recreate that table, then again it starts working for server2 too.

I am not able to find the reason and so not able to find the solution.

please help any one has resolved such kind of issue.

Thank you in advance,
Navnath Lanke

Post #1431886
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse