Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-18 : 23:45:30
|
| toni writes "We have a 3 tier VB application. The data access layer executes SQL server 7 stored procedure. Our stored procedure runs well in the office but fails in our customer site.The error message is as follows :[Microsoft][ODBC SQL Server][SQL Server]Distributed transaction completed. Either enlist this session in a new transaction or the null transaction.But it runs well when I run it directly in Query analyzer. I have checked book on line and does not find any solution.We and our customer use SQL Server 7 no service pack, O/S is Windows NT Server 4." |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2003-02-19 : 09:09:06
|
| This is related to the transaction handling in the component itself. First, investigate whether you really need to utilize distributed transactions. Personally, the only example I can think of that can benefit from the poor implementation of distributed transactions. But an immediate solution will require you to look at how your components handle the transactions. Are the classes setup to automatically start transactions, are they committing or aborting properly, etc. Chances are it's tied to a particular situation (data). |
 |
|
|
|
|
|
Error in executing stored procedure from COM component