Remote Data Access

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server CE » Remote Data Access

Remote Data Access

Rate Topic

Display Mode

Topic Options

Author

Message

nandhakumar.p

Posted Thursday, February 28, 2008 12:17 AM

Forum 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

Ian Yates

Posted Sunday, March 02, 2008 10:04 PM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, September 16, 2012 3:26 AM
Points: 1,038, Visits: 443

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

Rajesh Patil

Posted Tuesday, April 29, 2008 1:47 AM

Grasshopper

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 »

Permissions