Database Connection TimeOut with sql server

[loplayers]

I am using Labiew 8.2 and Connectivity toolkit to connect with MS sql Server 2005,
Sometimes the query can run very fast to get data, but ometimes it cosume a lot of time to execuate some unknown .vi.
Then, i press the highlight execuation that see what hapeen of the .vi, at that time, i can very fast to run the program.
FOr conclude, it means that the Highlight execuation can free the vi running. But it is not effecient and acceptable to do this.
Can anyone help me to solve this problem please.?

[Steven_C]

Hi loplayers,

I am a little unclear about the question. From my understanding, it appears that your query runs fast when it gets data and takes a lot of time to execute a particular vi. I am unclear on what you mean by if you go into highlight execution mode you can "very fast to run the program". It sounds like highlight execution is actually speeding up your execution speed which should not happen. This is why I believe that I am misunderstanding the question. Could you please clarify? Thank you!

Best regards,

Steven

[loplayers]

i am soory for my poor presentation. In my case, the program sometimes looping with the database select query .vi.
I wait for a long time for this looping, but i press the highlight execuation button that can end the looping for this .vi. I don't know the reason for ths special problem.Thanks

[Steven_C]

Hi loplayers,

Are you saying that highlight executoin mode is allowing you to get out of an infinite loop? Please confirm. Thanks!

Best regards,

Steven

[loplayers]

yes, the highlight execuation can end the loop.

[Steven_C]

Hi loplayers,

This is very odd. If you add a wait function in the loop, does this also exhibit the same behavior?

Best regards,

Steven

[loplayers]

it still doesn't work when i add a wait function in the loop with different ms.

[Steven_C]

Hi loplayers,

How long was the wait function within you code. I would try something to the order of 2000 to 4000ms for the purpose of this test. Please let me know. Thanks!

Best regards,

Steven