Monday, March 19, 2012

Multiple DataSources on a DataSourceView

I have added multiple tables from different data sources to a dsv. When I try to make a model from that DSV, it throws an error, saying that it can't find any of my tables that are not the primary tables. Is this a bug or am I missing something that I should be doing?

TITLE: Microsoft Visual Studio

An error occurred while executing a command.
Message: Invalid object name 'dbo.CategoryID'.
Command:
SELECT COUNT(*) FROM [dbo].[CategoryID] t


BUTTONS:

OK

Thanks!

Nathan

I have done a bit of research on the issue and I am now thinking it may be a problem w/ my databases, but I am not sure. What I do need is to confirm that someone has used DSV's that contain multiple datasources with success. Thanks!

Nathan

No comments:

Post a Comment