Remote Data Access

• nandhakumar.p

  Grasshopper

  Points: 24

  More actions

  February 28, 2008 at 12:17 am

  #184376

  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

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  March 2, 2008 at 10:04 pm

  #784294

  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...

• Rajesh Patil

  SSC Veteran

  Points: 219

  More actions

  April 29, 2008 at 1:47 am

  #808157

  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