Linked Server Problem

From: sk (soekkwan@mailcity.com)
Date: 08/22/02 

From: "sk" <soekkwan@mailcity.com>
Date: Wed, 21 Aug 2002 20:56:10 -0700

Hi,
My application need to access
2 databases in 2 diffrent SQL Servers.
The asp program accesses the local
database(SQL Server 2000 A) & then accesses to
the remote database(SQL Server 2000 B)
through linked server defined at SQL Server A
using a user with a password.
This user is defined at both SQL Servers.
My problem is when there is a query accessing data
at SQL Server B in between the Conn.BeginTrans
& Conn.CommitTrans block, the programs hang until hit
timeout
saying that timeout, need more time to process script..

Conn.BeginTrans
  ...
 'query to access data at remote database(server B)
  ...
Conn.CommitTrans

If the query is made outside of the
block(Conn.BeginTrans-Conn.CommitTrans)
then the program runs smoothly.
This problem does not happen at development server
but it does at production server.
Is it due to link-server permission or server roles
or user permission..??
Any ideas?
Any helps would be greatly appreciated.
Thanks in advance,
sk

Relevant Pages
Quantcast