Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distributed Transaction Error 1

Status
Not open for further replies.

stiller

Programmer
Aug 20, 2001
1
US
I am running a 3 tier application with the web server and COM+ object on one machine and my database on a seperate machine. Both machines are in the same domain. When I access my website externally for the first time I get the following error "[Microsoft] [ODBC SQL Server Driver]Distributed Transaction Error". The error will not appear again until no one has accessed the website for more than 20 minutes, essentially all session have been timed out.

This error only occurs when I access the website externally using the IP address. If I access the website internally using the machinename I will not get this error. I have tried uping the transaction timeout period to 3 minutes rather then the default of 60 seconds and that does not work.

I wanted to know if anyone has run into this problem and if they have a solution or any ideas I can try?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top