473,728 Members | 1,612 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

"Distribute d transaction completed. Either enlist this session in a new transaction or the NULL transaction."

"Distribute d transaction completed. Either enlist this session in a new
transaction or the NULL transaction."

I am recieving the above error when attempt to access a remote sql server
database 2000 (sp3a) from ADO.Net.
The database is on a windows 2003 machine and the ado.net code (web
services) are on another winsdows 2003 machine in the same domain. I have
configure the DTC to allow transactions and followed the resolution in the
following KB but I am still getting the error.

http://support.microsoft.com/?kbid=834849

Anyone got any ideas?

Cheers

Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.

Nov 16 '05 #1
3 27509
The answer was that the enterprise component (COM+) was 'hiding' certain
exception information and that the problem actual was a database table
constraint issue nothign related to the DTC

Ollie

"Ollie Riches" <ol**********@p honeanalyser.ne t> wrote in message
news:#$******** *****@TK2MSFTNG P15.phx.gbl...
"Distribute d transaction completed. Either enlist this session in a new
transaction or the NULL transaction."

I am recieving the above error when attempt to access a remote sql server
database 2000 (sp3a) from ADO.Net.
The database is on a windows 2003 machine and the ado.net code (web
services) are on another winsdows 2003 machine in the same domain. I have
configure the DTC to allow transactions and followed the resolution in the
following KB but I am still getting the error.

http://support.microsoft.com/?kbid=834849

Anyone got any ideas?

Cheers

Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.

Nov 16 '05 #2
Your MSDTC has timed out. You need to increase the timeout

"Ollie Riches" <ol**********@p honeanalyser.ne t> wrote in message
news:%2******** *******@TK2MSFT NGP15.phx.gbl.. .
"Distribute d transaction completed. Either enlist this session in a new
transaction or the NULL transaction."

I am recieving the above error when attempt to access a remote sql server
database 2000 (sp3a) from ADO.Net.
The database is on a windows 2003 machine and the ado.net code (web
services) are on another winsdows 2003 machine in the same domain. I have
configure the DTC to allow transactions and followed the resolution in the
following KB but I am still getting the error.

http://support.microsoft.com/?kbid=834849

Anyone got any ideas?

Cheers

Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.

Nov 16 '05 #3
Thank you for posting the result back into the newsgroup, it is really
appreciated. I am glad to hear that you got this working, I am always
interested in hearing about peoples experiences with Distributed
Transactions, especially regarding the upcoming 2.0 System.Transact ions.

--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/


"Ollie Riches" <ol**********@p honeanalser.net > wrote in message
news:eD******** ******@TK2MSFTN GP10.phx.gbl...
The answer was that the enterprise component (COM+) was 'hiding' certain
exception information and that the problem actual was a database table
constraint issue nothign related to the DTC

Ollie

"Ollie Riches" <ol**********@p honeanalyser.ne t> wrote in message
news:#$******** *****@TK2MSFTNG P15.phx.gbl...
"Distribute d transaction completed. Either enlist this session in a new
transaction or the NULL transaction."

I am recieving the above error when attempt to access a remote sql server database 2000 (sp3a) from ADO.Net.
The database is on a windows 2003 machine and the ado.net code (web
services) are on another winsdows 2003 machine in the same domain. I have configure the DTC to allow transactions and followed the resolution in the following KB but I am still getting the error.

http://support.microsoft.com/?kbid=834849

Anyone got any ideas?

Cheers

Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer helping programmers.


Nov 16 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1890
by: dcrespo | last post by:
Hi all... Here is my infrastructure design of a "distributed" system: - Many (30-50) hosts connected via VPN to a server. - Each host manages a system that receives local data (stored in a local database), and has to be sent to the server, so the rest of the hosts can "see" this data. What I want? I want to have a portable/changeable/easy-installation/cross-platform local database.
3
2170
by: Lada 'Ray' Lostak | last post by:
Hi ! We are moving to PgSql application, with 'typical' style of work. Thin client, huge database. From database is (also) generated whole website. I will use it for explain my current todo. Right now, I am before solving following problem: Someone starts (let's say) adding 'new product'. It mean, he have to add records to many tables, gfxer have to create proper images and some XML/HTML code, ppl translating to other languages have...
3
2576
by: Vic | last post by:
Dear All, I have a database of laboratory records in Access 2000. There is one form which acts as an interface to input experimetal data. This form incorporates information from several tables. I have a flag (yes/no field) indicating whether a particular experiment (one record) is completed (ie all data belonging to that record is inputted and quality controlled). What I want is that when I change the flag to "yes" the particular record...
3
2427
by: Peter Theill | last post by:
Hi, I'm trying to include the content of a request into an Xml document: if (System.Web.HttpContext.Current.Session != null) { XmlDocument d = new XmlDocument(); d.Load(new XmlTextReader("http://localhost/page.aspx")); } The requested page (page.aspx) is an XHTML page so I'm able to parse it as a
1
2253
by: Axel Dahmen | last post by:
Hi, today I've had a strange DTS error: In one of my transformations I'd been using several Copy Column transformations + one ActiveX transformation using a lookup function. This lookup function uses a second connection to the same SQL server but to a different database. I'm using this function to populate a new column in a table with calculated values. The transformation didn't run, I got an "Transaction context in use by another...
1
1405
by: craigkenisston | last post by:
I'm creating a paging control in which I want to use a session saved dataview : public class PagingControl : System.Web.UI.UserControl .... .... public void whatever DataView dw; if (Session != null)
1
1424
by: optimistck | last post by:
A mistake was made and "old" transaction logs (and old backups) were deleted. It appears that a long living transaction was living in one of those logs. Now the EP shows (no items). The DBs themselves are still functioning OK, just the EP shell that's not working. What's the proper resolution? Thank you in advance, FBCK
4
2101
by: R.A.M. | last post by:
Hello, I am writing ASP.NET application in which I need to use User Profiles and Session mechanisms. Here I include part of my source code (Admin.cs): using System; using System.Data; using System.Data.Sql; using System.Data.SqlClient; using System.Data.SqlTypes;
10
25965
by: Kurda Yon | last post by:
Hi, I set the register_globals off and try to get my code working under the new conditions. I stuck on the following problem: Warning: Unknown(): Your script possibly relies on a session side- effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting...
0
9418
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9272
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9196
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9129
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8124
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6013
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4524
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3235
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2160
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.