Remote Data Access

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



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

  • If you dont mind can you put the code patch that attempts to switch the connections in the two places.



    MBA-IT (Software Dev & Mgmt)

    SCIT 07-09

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply