Mouse Drag Operation Failed While Creating DataSet

[SteveKing]

I'm trying a simple drag operation from a valid data connection in server
explorer to the design surface of a new DataSet and get the subject error.
The detail says it could not retrieve schema information for table or view.
This happens for every connection. I've been using VS2008 for at least a
year without problem having built a number of windows applications and now I
am unable to even create a dataset unless I do it manually. This is not
generally an option because of the size of the tables. The only thing I've
done recently is import symbol tables and I don't see that there could be a
connection to my problem and that action.

I've searched the Internet for a solution but have been unsuccessful. I'm
connecting to a SQL Server 2000 database so the one problem about MySQL
drivers doesn't apply.

[SteveKing]

I spent a LOT of time running down the solution to this problem. There were
plenty of references to failing a mouse drag operation to the dataset and
finally I got the clue 'Could not load file or assembly
'Microsoft.SqlServer.Types'. It cleared up after I installed the 'Microsoft
SQL Server System CLR Types ' from
http://download.microsoft.com/download/b/9/a/b9a78047-d269-4a25-88a1-9c4321d90677/instructions_enu.htm

I hope this saves someone else from wasting a couple days running this down.

[adnank...@gmail.com]

thanks steve king u saved my time