.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

MSDTC between 32-bit and 64-bit systems?

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
 
Hello, I have recently updated my dev machine to Windows 7 64-bit. I am having an issue when developing using MSDTC. Basically, any transactions I try to fire from my local machine timeout. When I run dtctester I get an error stating that it could be any of the following: Firewall issues Bad Wins/DNS entries Misconfigured Network Misconfigured SQL Server The server is a Windows Server 2003 32-bit. I cannot ping my local machine from the database server. I have read a few articles stating that you can't use NETBIOS names between 32-bit and 64-bit systems but I have seen hotfixes for similar issues, just not for this exact issue. So basically is there any way to get MSDTC to work between 32-bit and 64-bit systems? If so, how? Thanks!   jfkrueger


View Complete Post


More Related Resource Links

Systems Development Life Cycle (SDLC)

  
The systems development life cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project, from an initial feasibility study through maintenance of the completed application. Various SDLC methodologies have been developed to guide the processes involved, including the waterfall model (which was the original SDLC method); rapid application development (RAD); joint application development (JAD); the fountain model; the spiral model; build and fix; and synchronize-and-stabilize.

Dynamic Systems Development Model (DSDM) Methodology

  
The Dynamic Systems Development Model was developed in the U.K. in the mid-1990s. It is the evolution of rapid application development (RAD) practices. DSDM boasts the best-supported training and documentation of any of the agile software development techniques, at least in Europe. DSDM favors the philosophy that nothing is built perfectly the first time and looks to software development as an exploratory endeavor.

Transactions: Build Scalable Systems That Handle Failure Without Losing Data

  

Systems that handle failure without losing data are elusive. Learn how to achieve systems that are both scalable and robust.

Udi Dahan

MSDN Magazine July 2008


Editor's Note: Systems Programmers

  

In our first 20 years in print, we have covered a lot of new product releases. Back in the 1980s and 1990s it was a series of OSs that drove developer innovations. However, in the past five years the programming landscape has changed.

Joshua Trupin

MSDN Magazine October 2005


Editor's Note: Connected Systems Developer Competition

  

Last month, we told you about a contest to help design the next-generation PC hardware and we know you're working feverishly on your entries for that. Well, this month we have news of an even more exciting competition-one that MSDN Magazine is proudly co-sponsoring.

Joshua Trupin

MSDN Magazine August 2005


Code Name Indigo: A Guide to Developing and Running Connected Systems with Indigo

  

This article describes a collection of new programming frameworks that are part of "Longhorn," the upcoming version of Windows. "Indigo," the code name for this framework, provides rich support for service-oriented design that is complementary to traditional object-oriented approaches. Indigo marries the best features of .NET Remoting, ASMX, and .NET Enterprise Services into a unified programming and administration model. Indigo's deep support for standard protocols, including HTTP, XML, and SOAP, makes it easier to integrate applications and services without sacrificing security or reliability.

Don Box

MSDN Magazine January 2004


Virtual Source Code Control Systems: Promoting and Managing Projects using Visual SourceSafe

  

Source code control systems like Microsoft Visual SourceSafe can simplify just about any development project, and make it easier for your code to move safely among individual programmers, development teams, and project stages. Visual SourceSafe provides an object model that you can use as the basis of your own customized source code control environment. To give you an idea of what is possible, we'll walk you through the elements of a browser-based source code control system built with Visual SourceSafe, ASP, and VBScript. This simple system lets members of your team build, label, and promote individual files or entire projects, and to reverse promotions.

Ken Ramirez

MSDN Magazine May 2000


Creating .NET Assemblies That Aggregate Data from Multiple External Systems for Business Connectivit

  
This article describes a quick, four-step process for creating a .NET assembly that BCS can use to retrieve external data for SharePoint Server 2010 by using Visual Studio 2010.

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

  
Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Sample: Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint

  
Download sample code as you learn to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Facing MSDTC related issues while archiving data from one database server machine to another databas

  
I have a question with respect to distributed transactions when carried out between two database server machines on the same network.   Consider there are two database server machines \SOURCE_DATABASE_SERVER\ and \DESTINATION_DATABASE_SERVER\. Now we have to archive the data from one database server to other database server.   Let us suppose the database server \SOURCE_DATABASE_SERVER\ is the live production database server and \DESTINATION_DATABASE_SERVER\ is Long term storage database server. Now data from \SOURCE_DATABASE_SERVER\ needs to be archived into the database server \DESTINATION_DATABASE_SERVER\.   So I have written a dynamic stored procedure which includes distributed transaction (begin Tran, commit Tran, rollback            Tran) coding in it.   Now initially when I executed the procedure, it gave some of the following errors   1) OLE DB provider "SQLNCLI" for linked server "\DESTINATION_DATABASE_SERVER\" returned message "The partner transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 1 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "\DESTINATION_DATABASE_SERVER\" was unable to begin a distributed transaction.    

How large do you make your MSDTC Physical Disk Resource?

  
MSDTC requires a physical disk resource for the 4mb log it uses.  How large do you typically make the disk used as the MSDTC Physical Disk resource?  I don't know if there is a need to go beyond 4MB.  I'm guessing 100MB is a safe number.  Do you agree? Thanks,    Dave

Dependency of IP , n/w , Disk in MSDTC.

  
have installed sql server 2005 cluster but never 2008 ,now I have got this chance but I am not understanding how to create dependency of IP , n/w , Disk in MSDTC. What are the domain user rights ?Actually my previous site was given the writes of domain admin to the sqluser now it is giving me problem.??"SQLSERVER DBA" "INDIA"

How to move MSDTC to another Cluster Group?

  
Hello,   We have 2-node, 1-instance cluster (64-bit Windows 2003 and 64-bit SQL 2005). We now want to add another sql instance. Currently, MSDTC resource is under the existing sql cluster group.   We want to move it to a new its own cluster group, or move it to the cluster group along with Quorum, Cluster name, cluster ip resources.   Is it as easy as removing from one cluster group and adding to another group?   Thanks,   Ada    

Upgrade from SQL 2005 to SQL 2008 cause problems with MSDTC

  
We have recently upgraded our server from SQL Server 2005 to SQL Server 2008.  Previously we were running our asp.net application using MSDTC with no problems. Since we upgraded, we are encountering problems that seem to relate to Multiple Active Result Sets (MARS).  The error we receive is: "There is already an open DataReader associated with this Command which must be closed first" when we try and perform a save process.  To fix this problem we added MultipleActiveResultSets=True to the connection string.  We now get the error: "The transaction operation cannot be performed because there are pending requests working on this transaction." Within the transaction scope we save to a table and then load from the same table.  Our stack trace indicates this is where the first error occurs.  Again, this transaction worked using SQL Server 2005. If we do not use MSDTC by putting Enlist=false in the connection string, the request works. We are really stumped as to what to do.  We would prefer not to have to role back to SQL Server 2005 and would also prefer not to have to have sweeping code changes in our application.  We have test MSDTC by using DTC ping on our servers and it works. Your help is greatly needed and would be greatly appreciated. Regards, Steve and Nilesh

Upgrade from SQL 2005 to SQL 2008 cause problems with MSDTC

  
We have recently upgraded our server from SQL Server 2005 to SQL Server 2008.  Previously we were running our asp.net application using MSDTC with no problems. Since we upgraded, we are encountering problems that seem to relate to Multiple Active Result Sets (MARS).  The error we receive is: "There is already an open DataReader associated with this Command which must be closed first" when we try and perform a save process.  To fix this problem we added MultipleActiveResultSets=True to the connection string.  We now get the error: "The transaction operation cannot be performed because there are pending requests working on this transaction." Within the transaction scope we save to a table and then load from the same table.  Our stack trace indicates this is where the first error occurs.  Again, this transaction worked using SQL Server 2005. If we do not use MSDTC by putting Enlist=false in the connection string, the request works. We are really stumped as to what to do.  We would prefer not to have to role back to SQL Server 2005 and would also prefer not to have to have sweeping code changes in our application.  We have test MSDTC by using DTC ping on our servers and it works. Your help is greatly needed and would be greatly appreciated. Regards, Steve and Nilesh
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend