SQL problem, MSDTC Problem or VB.NET problem? 
Author Message
 SQL problem, MSDTC Problem or VB.NET problem?

Hello,

I have a very strange behaviour of one of ours web applications.

I have the user interface in VB.NET, I have the business logic layer as
VB6 COM components running as COM+ applications(W2K SP3) and the data
layer
SQL 2K SP2.
I have two SQL Servers one live and one for test the only difference is
that the live server has some more security updates so the versions of
SQL differs slightly
Live: 8.00.578
Test: 8.00.534

I have a form in VB.NET(ASP.NET) that updates some information
concerning an user(last name, first name and email).
When I want to update this information on the live server I can see in
the database the lines that were modified (I hold theese values in the
database as attributes so I have a line for each name and one for email)
but if I wait for 5-15 seconds those lines diappear from the database.
It is a strange behaviour as if I use the test server this doesn't
happen.

I tried using profiler but I had no stetemen that executes a delete in
that table.

Any idea where I should check?
Thanks
Florian



Mon, 04 Apr 2005 00:03:58 GMT
 SQL problem, MSDTC Problem or VB.NET problem?

It looks like an unexpected rollback to me, Profiler should be able to tell
you that the distributed transaction is started, committed or aborted.


Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright ? SQLDev.Net 1991-2002 All rights reserved.


Quote:
> Hello,

> I have a very strange behaviour of one of ours web applications.

> I have the user interface in VB.NET, I have the business logic layer as
> VB6 COM components running as COM+ applications(W2K SP3) and the data
> layer
> SQL 2K SP2.
> I have two SQL Servers one live and one for test the only difference is
> that the live server has some more security updates so the versions of
> SQL differs slightly
> Live: 8.00.578
> Test: 8.00.534

> I have a form in VB.NET(ASP.NET) that updates some information
> concerning an user(last name, first name and email).
> When I want to update this information on the live server I can see in
> the database the lines that were modified (I hold theese values in the
> database as attributes so I have a line for each name and one for email)
> but if I wait for 5-15 seconds those lines diappear from the database.
> It is a strange behaviour as if I use the test server this doesn't
> happen.

> I tried using profiler but I had no stetemen that executes a delete in
> that table.

> Any idea where I should check?
> Thanks
> Florian



Mon, 04 Apr 2005 11:39:18 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. INSERT into access database using vb.net/ado.net..problem

2. Challenging SQL / VB .net problem!!

3. VB.Net SQL-DMO EnumUsers problem

4. VB 4.0 & SQL*Net 2.0 Problems

5. SQL, VB, Access, Queries, Join Problem, and Newbie Problem

6. Paradox problem on the NET - problem

7. SQL Server 2000 MSDTC problem

8. MSDTC problem on SQL cluster

9. MSDTC for SQL 6.5 Service Problem

10. SQL MSDTC clustering problems

11. MSDTC problem in SQL Server 2000 cluster environment

12. Problems with com adodb.command in vb.net


 
Powered by phpBB® Forum Software