I had a tsql script that I was running from the SQL script explorer. It loads up some temp tables and mangles them some. At the end there are two select statements that return records.

I take the results of these queries and pate them into excel. The first one works fine but copy and pasting from the second grid freezes the program and it dies not recover.

Let me clarify a little.

After I paste the second record set into excel I then click back over on SQLDBControl and then SQLDBControl freezes. I get the hourglass and the program not responding messages from Vista.

I am testing now to see if I just run the script and copy the second record set if it freezes. If I copy the first record set and then the second I know that I can reproduce the problem.

Thanks!

I just found out that it pasted the same data, the first dataset, twice.

ddriver:

Let me clarify a little. After I paste the second record set into excel I then click back over on SQLDBControl and then SQLDBControl freezes. I get the hourglass and the program not responding messages from Vista. I am testing now to see if I just run the script and copy the second record set if it freezes. If I copy the first record set and then the second I know that I can reproduce the problem. Thanks!

I've tried to duplicate this problem by returning a couple of record sets and I haven't been able to duplicate this so far.

If you haven't tried already, could you try running the script such that it only returns one record set, specifically the second record set?  I'm wondering if there's something about that record set in particular that is causing this issue? (maybe an unusual character that we aren't handling correctly).

Also, if you right-click on the top-left area of the grid (immediately to the left of the first column name) you have the option to export to CSV.  Try that and see if that works.  It doesn't solve this problem  but I want to see if there's something about copying or saving the data that is causing the problem.

---

SQLDBcontrol Support

support@sqldbcontrol.com

It freezes the same with only the second record set.

Exporting the recordset to CSV is serviceable, just as running the query in enterprise manager.

It is interesting that when I paste it drops the data from what ever was on the clipboard prior to copying form the result set.

I did a quick search of the dataset and didn't have any special characters jump out at me. How would you narrow this down?

That's interesting.  It seems like, for whatever reason, the copy is just not working for this specific record set.

Can you change the output format to text?  It's possible that this will fail with an exception, which might provide a better clue.

How big is the record set?  If it's a particularly large record set that might be a clue but I'm pretty sure I've Copied large (tens of thousands) of records into the clipboard before.

If the size isn't a factor (which I doubt) I'd probably start by removing columns from the record set (say 2 or 3 at a time) and see if that works.  Hopefully that will help narrow it down to one column.

If you can narrow it to one column then, assuming the data isn't sensitive, if you could copy it into a notepad document and send it to us (support@sqldbcontrol.com) then we could have a look at it.  For the purpose of copying it into notepad, I suggest you change the output mode to text and the run the query.  The data type of the column will also be useful.

---

SQLDBcontrol Support

support@sqldbcontrol.com

I can pull it back as a text result set without problems.

This data set has about 650 rows and 150 columns.

It would be nice if it threw and exception but it just sits there not responding.

I can spend a little more time trying to narrow this down but not much.

I was hoping it might have fewer columns.  It may well be the number of columns - we'll run some tests with over 150 columns and see that causes any issues.

---

SQLDBcontrol Support

support@sqldbcontrol.com