First things first....

1. Is your query optimized? Have you run it through the sql analyzer?

2. Are you using a stored proc? If not - you should be. At most - your client should do nothing more than make a proc call and pass any required parameters.

3. Since all you are doing is running a query, scap the cursor adapter and just instance an ado command object - setting the command text to your proc and populating the various parameter objects.

The cursor adapter is a hunk of junk...you are far better off handling things on your own...

Even if you still elect to use the cursor adapter, at the very least, get your stuff into a stored proc and test from query analyzer. Once you have things working on the server - then try to call from a client.