Sample db problem ...

Hi all,
I'm a new guy trying to tutor myself on MRS and I'm using
SQL05DEV on my desktop. I managed to finally get connected to
the sample AdventureWorks db that the built in tutorial uses. When I run
this query:
SELECT S.OrderDate, S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastName
FROM HumanResources.Employee E INNER JOIN
Person.Contact C ON E.ContactID = C.ContactID INNER JOIN
Sales.SalesOrderHeader S ON E.EmployeeID = S.SalesPersonID
=====================================================
I get this error:
TITLE: Microsoft Report Designer
--
An error occurred while executing the query.
Invalid object name 'HumanResources.Employee'.
--
ADDITIONAL INFORMATION:
Invalid object name 'HumanResources.Employee'. (Microsoft SQL Server, Error:
208)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
---
Any tips for troubleshooting?
What am I missing ?
The Microsoft ink above yields no help.
How would I check to see if the human resources table even exists?
Thanks,
>ScottI think your datasource is pointing to some other database. If you have
installed all component of sql 2005
at Run type sqlwb this will open management studio. connect to the sample
database "AdventureWorks"
and check for the table. If it exists. Go to BID open your project and check
for the datasource and try to select the same server and database and "Test
connection" and see whether it connects. if everything goes well you should
get the result.
Amarnath
"iamscott" wrote:
> Hi all,
> I'm a new guy trying to tutor myself on MRS and I'm using
> SQL05DEV on my desktop. I managed to finally get connected to
> the sample AdventureWorks db that the built in tutorial uses. When I run
> this query:
> SELECT S.OrderDate, S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastName
> FROM HumanResources.Employee E INNER JOIN
> Person.Contact C ON E.ContactID = C.ContactID INNER JOIN
> Sales.SalesOrderHeader S ON E.EmployeeID = S.SalesPersonID
> =====================================================> I get this error:
> TITLE: Microsoft Report Designer
> --
> An error occurred while executing the query.
> Invalid object name 'HumanResources.Employee'.
> --
> ADDITIONAL INFORMATION:
> Invalid object name 'HumanResources.Employee'. (Microsoft SQL Server, Error:
> 208)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
> ---
> Any tips for troubleshooting?
> What am I missing ?
> The Microsoft ink above yields no help.
> How would I check to see if the human resources table even exists?
>
> Thanks,
> >Scott
>