Hi Herbie68nl,
As far as I understand, you want to pass several SQL requests at once. This is impossible in ADO.
You need to think on how to change your request so that it selects all data you need, but in one call.
Hi Herbie68nl,
As far as I understand, you want to pass several SQL requests at once. This is impossible in ADO.
You need to think on how to change your request so that it selects all data you need, but in one call.
Thank you Tanya for your answer.
I already thaougt about this. But cound find a way to do this. We want to simulate the load to SQL from our application, and therefore I need to do it this way.
But 'Can't be done' is also an answer and maybe it is the most clear answer of all. We are arleady searching for other tools where we can do this kind of testing.
This behavior isn’t related to TestComplete. You use ADO in this sample. This is one of the main specifics of ADO. If you want to test the load of your SQL server, I would suggest that you look at TestComplete’s Distributed Testing feature. Instead of executing the requests one by one (as you currently do), you can execute them simultaneously. I’m not familiar with your requirements, but that sounds reasonable for me.
