Hi We were excited by the potential of TransactionScope to simplify our data access code, eliminating the need to pass around a database transaction.After playing around with .NET 2.0 for a while we were very disappointed to find that unless you used the exact same connection object and kept it ...

Ahhhhh Microsoft, the most important feature in 2.0 “Transactions” is poorly documented, and almost working, as it looks like the people who developed it got it to work under one scenario, and released it immediately, never tested completely.It is like, hey, does windows xp connected to a ...

Hello everyone, We have a 3-tier application, the client, the server and the databaser server. It was developed using C# 2.0 and .Net 2.0, the database server is MS-SQL 2000 and we have some MSMQ in there. All 3 are located on different machines. The client is Windows XP SP-2, the application ...

We have an application comprising of two discrete components (a .NET 1.1 COM+ component, and a legacy ODBC component), which operate on the same SQL Server data (same database rows) within the same distributed transaction. We use the ITransactionExport/Import interfaces to propagate the DTC ...

Hi,Given the following WS-AT 2PC txn scenario: -1) All remote WS-AT Transaction Managers have responded PREPARED to the coordinating msdtc TM, and the outcome of the transaction is COMMIT2) The network link to one of the participating TMs is broken before a COMMIT command could be sent.Does the ...

Hi,I am very new to this enterprise services based programming (COM+).I have created a Enterpriseservices based component with the TransactionOption property set to 'Supported'. Now, I would like to know the following things.How to handle database related queries which dont require any type ...

I have a VB windows app using a dataset with multiple datatables and a datagridview for the UI. Okay. I have the datatable. updates and inserts and deletes working. Now, I just want to wrap the calls to the different table updates/inserts/deletes in a single transaction so I can manage the ...

<div>Hi Wonder if anyone can offer some advice on the following...... I am looking to increase the constructor string length in the Windows COM component services from 512 to 1024. Does anyone know if this is possible? Any advice greatfully recieved Kind Regards Christoffa</div>

I have an application which uses an implicit transaction using Transaction Scope when edits are saved to the SQL 2K server. MSTDC must be enabled on the client PC. Can someone please provide me with an example of how I can programmatically configure the client PC MSDTC settings for them? Right ...

Hi,It appears that DTC is not fulfilling its end of the bargain when it acts as coordinator in a distributed TIP transaction.I deliberately killed my Transaction Manager after it had successfully returned a PREPARED response to the DTC. I then pulled the plug (literally) on the network ...

Hi,I am using transactionScope and it is failing. I tried DTC Ping as was recommended in another post and it fails to. On the computer I try to ping:++++++++++++Start Reverse Bind Test+++++++++++++Received Bind call from DEVELOPTrying Reverse Bind to DEVELOPError(0x2AFC) at nameping.cpp ...

SCENARIOSuppose I call the following method in a ServicedComponent:public void DoMixedUpdates(){ DoDBUpdateA(); DoDBUpdateB(); CallWebService1ToDoDBUpdateC(); CallWebService2ToDoDBUpdateD(); DoDBUpdateE(); DoDBUpdateF();}All 6 calls perform DB updates but the middle 2 calls call "plain old" ...

Hi people.Im using source code from a microsoft self paced book(70320) to create and consume a component (com+)when I try to build the project I get the following message:Program 'C:\EC70320\BankAccounts\obj\Debug\BankAccounts.exe' does not have an entry point definedI've created the snk ...

It's really dissappointing to see how poor the .NET documentation is for using IEnlistmentNotification to create a durable RM that also uses RecoveryInformation().My goal is incredibly simple: recreate the CompensatingResourceManager MSDN sample ...

Hi all, I build a webservice to access a COM+ application. I install the com+'s proxy in my machine, but when I run the webservice, appear this error ( in portuguese, that is my original language):System.UnauthorizedAccessException: Falha na recupera&#231;&#227;o de factory de ...

It's really dissappointing to see how poor the .NET documentation is for using IEnlistmentNotification to create a durable RM that also uses RecoveryInformation().My goal is incredibly simple: recreate the CompensatingResourceManager MSDN sample ...

SCENARIOSuppose I call the following method in a ServicedComponent:public void DoMixedUpdates(){ DoDBUpdateA(); DoDBUpdateB(); CallWebService1ToDoDBUpdateC(); CallWebService2ToDoDBUpdateD(); DoDBUpdateE(); DoDBUpdateF();}All 6 calls perform DB updates but the middle 2 calls call "plain old" ...

SCENARIOSuppose I call the following method in a ServicedComponent:public void DoMixedUpdates(){ DoDBUpdateA(); DoDBUpdateB(); CallWebService1ToDoDBUpdateC(); CallWebService2ToDoDBUpdateD(); DoDBUpdateE(); DoDBUpdateF();}All 6 calls perform DB updates but the middle 2 calls call "plain old" ...

Hi,We are currently trying to use IProcessInitializer in our COM+ components in order to perform some preparation/cleanup of resources when dllhost is loaded/unloaded. We can't find too much actual information about people using it so it's a bit hard to try and figure out how it works.We are ...

We have a third-party workflow server process that exposes a plain old managed .NET API with the following the following methods:1. Connecting to the server2. Setting datafields within the server3. Causing the datafields to be updated within server4. Closing the serverWe have a business object ...

Hello everybody, I need a little help in order to investigate an Error using ITransactionImport::import method.It seems that the transaction cookie used in several transaction operations become invalid if one of this operation fails without an explicit operation by our side.We need to perform 4 ...

Hi, I'm a little bit confused with this new System.Transactions namespace. I was able to understand its propose, but it looks like it is the replacement for EnterpriseService (ServicedComponent) when all you want from COM+ is the transaction coordination. I'm about to start a new project and ...

I'm very annoyed by the change in nested transactions. Previously it was perfectly ok to nest a transaction with a different isolation level to the current Tx providing it didn't ask for a stronger isolation level. Now it seems it has to be exactly the same. This has made porting from ...

i have a client application cli calling COM+ assembly (comA) thru application proxy (exported from the server machine). comA references other COM+ assemblies such as comB, comC and comD. Now the client cliA does not talk to comA until you copy the assemblies comB, comC and comD into the folder ...

Hi, I was wondering if any of you guys have encountered the following problem using system.transactions object. I have two databases running Oracle 8.1.4.7.0 and have Oracle 9i client. When i run distributed transaction on these two databases and raise an exception to see if the transaction is ...

Tried it with transactionscope and it didn't rolled back. Doe's it work with transactions ? Thanks Avi harush

As I understand it, if you open a second SQL connection within a transaction it will automatically be promoted from a Lightweight Transaction (LT) to a full DTC version. However, normal advice with ADO is to utilise connection pooling by simply opening the connection and closing it ASAP. ...

Hi,I developed a .NET serviced component with Framework .NET 1.1, instaled it in a win2k SP4 server (COM+ 1.0) and marked that component with Transactions=Required. This application server communicates with a SQL Server 2000 SP3 database server inside the same subnet/domain. When a simple ...

I'm in the process of converting a .net 1.1 program to use System.Transactions. However, I've hit a problem. The current code creates a ES version of a transaction scope and sets the equiv' TransactionScopeOption to "Supports" which means enlist in a transaction if one is there ...

We use complus extensively for our ERP. In one particular installation, the security setting is "This user" and everything works perfect, but when the next day (as complained by the customer) the user re-enters into the app, the call doesnt get authenticated. One workaround we found ...

I am trying to wrap some DB calls in a com transaction for testing purposes (make a bunch of calls to the DB, check if they look right, rollback any changes, move on to next test).So far it works fine running against a local SQL Server, but I can't get it to work against our actual development ...

Is it possible to use transactionscope and in the {} to use sql and msmq? msmq is the datasource and the sql is the target. I wan't it to be transactional Could't find a sample for it . Is that possible ? Thanks Avi

Hi all, Could anybody knows where I could find the example of distributed transaction in wcf using ws-at? So it enables 3rd party service (like IBM svc) to join the transactions. Thank you in advance. lingga

Hello, I need help with this topic...I'm working with Visual Studio 2005 and SQL Server 2005 DB within a Simple Local Network. I receive a Message:"The asociated transaction administrator has disabled its support of remote or network transactions" (it's in spanish, so I did translate it to ...

Hello, I need help with this topic... I'm working with Visual Studio 2005 and SQL Server 2005 DB within a Simple Local Network. I receive a Message: "The asociated transaction administrator has disabled its support of remote or network transactions" (it's in spanish, so I did translate it to ...

Why does the following promote to DTC when using SQL Server 2005? All tableadapters are using the same connection so surely the transaction can stay lightweight? using (SqlConnection conn = new ...

I am writing some code to test the possiblity to use COM+ enterprise transaction to rollback procedures in our DB tests. So for each test, begin a transaction, then run stored procedures, then call SetAbort() to rollback everything. Then run the next test. Our stored procedures are all have ...

Hello, we want to build Dot net Distributed application. means we want place our Logic DLL (Dotnet Assembly) in different mechine as hosted by COM+ server. and want access this in client side (in UI layer). How we can access it without using Remoting or Webservices. Is it possible? How we can ...

Hi everyone, I am having some trouble with the DTC on a client machine and need help to get it working. The problem started while doing some experimenting with the new WCF stuff, but has evolved into a simple client side dtc problem. In a nutshell, I can't get dtctester utility to work. Some ...

Hi everyone, I am having some trouble with the DTC on a client machine and need help to get it working. The problem started while doing some experimenting with the new WCF stuff, but has evolved into a simple client side dtc problem. In a nutshell, I can't get dtctester utility to work. Some ...

Does anyone know how to resolve this exception. Exception: Message: Communication with the underlying transaction manager has failed. Stack Trace: System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed. > ...

Hi all, On an XP sp2 system (using fat32), I try to run a COM+ server using XA transaction with oracle 10 client. I have a "8000D048" error in the server application. and I can see in the event log a message telling me to add the XADLL key in the HKLM/software/microsoft/msdtc registry. I ...

Hi everyone! I suppose you've allready heard of this error, I've searched for answers on many other forums and groups but I didn't find a clear answer. So, for something to begin with - I am working on a VB 6.0 - 3 layered application and I get the error when the business layer is trying ...

Maybe this is obvious to everyone, but it took me a while to figure out. I am experimenting with a durable resource manager that is supposed to live inside an assembly that is loaded into the client application program process. I have noticed that sometimes the Commit() method is never called ...

Event Type: WarningEvent Source: MSDTCEvent Category: SVCEvent ID: 53258Date: 5/22/2006Time: 4:02:41 AMUser: N/AComputer: EPCDescription:MS DTC could not correctly process a DC Promotion/Demotion event. MS DTC will continue to function and will use the existing security settings. Error ...

Can MSDTC abort\rollback transaction if I create instance of COM-object (COM object marked as "Transaction - Not supported" in "Component Services" snap-in) during "transactioned" part of .NET code ?Which way MSTDC will act?

I want to write a program to monitor COM+ transactions. Does anyone know how to write in VB6 to count the numbers of active transactions held in COM+ server?

I have implemented transaction using Service Config using DotNet with Oracle 9i as back end. Some times we are geting the following error ORA 02051: Another session in the same transaction as failed. Whether any body has faced this problem before. Waiting for resolution. Thanks in advance ...

Source: System.Transactions.TransactionInDoubtException: mscorlibText: The transaction is in doubt I'm getting the following error is a very specific circumstance and I don't understand why. I've got a single unavoidably long running transaction (~90mins) that I run from a .net component ...

Forgive the lameness of this question. I am part of a team that has developed a Visual Studio 2005 web application that currently uses MSDTC and Microsoft Enterprise Library. The problem is that my hosting team will not run the MSDTC as a service as they say it opens up too many ports to the ...