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

Ollie Riches

"Distributed 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

Subscribe Post Reply

27472

Ollie Riches

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**********@phoneanalyser.net> wrote in message
news:#$*************@TK2MSFTNGP15.phx.gbl...

"Distributed 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

Stan

Your MSDTC has timed out. You need to increase the timeout

"Ollie Riches" <ol**********@phoneanalyser.net> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...

"Distributed 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

Angel Saenz-Badillos[MS]

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.Transactions.

--
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**********@phoneanalser.net> wrote in message
news:eD**************@TK2MSFTNGP10.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**********@phoneanalyser.net> wrote in message
news:#$*************@TK2MSFTNGP15.phx.gbl...
"Distributed 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

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...

Python

"Transaction over connections"

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....

PostgreSQL Database

Changing "completed" records to "read only"

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....

Microsoft Access / VBA

Use "Session" from page requested by code

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...

ASP.NET

DTS Transformation Error: "Transaction context in use by another session."

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...

ASP.NET

Can I use "Session" inside a user control ?

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...

ASP.NET

Deleted "old" transaction logs = (no items) in EM. How to recover?

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...

Microsoft SQL Server

"Profile" and "Session" not accessible in ASP.NET app

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...

ASP.NET

"register_globals off" and "session side-effect"

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-...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

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

Similar topics