Mouse Drag Operation Failed While Creating DataSet

550 views
Skip to first unread message

SteveKing

unread,
Feb 23, 2009, 4:06:01 PM2/23/09
to
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

unread,
Feb 23, 2009, 7:34:02 PM2/23/09
to
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

unread,
May 22, 2014, 7:58:43 AM5/22/14
to
thanks steve king u saved my time
Reply all
Reply to author
Forward
0 new messages