Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Remote Data Access Expand / Collapse
Author
Message
Posted Thursday, February 28, 2008 12:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 29, 2008 2:19 AM
Points: 2, Visits: 7
Hi Friends,

when our application switches between DB and RDA(Remote Data Access) connections. We close the DB connection and create the RDA object and then execute the pull statement.Once the PULL statement is executed we close the RDA connection and open the DB connection. This is working fine but sometimes, in the RDA connection when we execute the PULL statement sql quries, it is not returning any message or error number.It simply hangs.

wwhat could be the reason?
Kindly clarify our doubts.

Thanks in Advance.

Regards,
Nandha
Post #461448
Posted Sunday, March 2, 2008 10:04 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444
Could you run SQL profiler against your server to see if any SQL command is being executed? If so then you can move on to seeing why it is hanging...


Post #462982
Posted Tuesday, April 29, 2008 1:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 23, 2008 8:31 AM
Points: 15, Visits: 21
If you dont mind can you put the code patch that attempts to switch the connections in the two places.
Regards,
Rajesh
MBA-IT (Software Dev & Mgmt)
SCIT 07-09
Post #491881
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse