Database Invalid Object Name

[skatedork]

Ok so I am upgrading from a coldfusion 4.5 site and I set everything up,
however, I am getting the following error whenever I try to connect to a
database table. I checked my permissions and they seem to be fine. This all
worked before I did the transfer.

Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name
'PRODUCT_HIERARCHY'.
The error occurred in C:\web\[url]www.drs.com\custom[/url]
tags\setApplicationGlobalVars.cfm: line 642

The SQL I am trying to run is as follows:


<CFQUERY NAME="getHierarchy" DATASOURCE="DRSWEB">
SELECT A.product_hierarchy_id, A.product_group_id, A.product_category_id,
A.product_sub_category_id, A.product_id,
C.Group_name, D.category_name, E.sub_Category_name, F.product_name
FROM PRODUCT_HIERARCHY A LEFT OUTER JOIN PRODUCT_GROUP C on
A.product_group_id = C.product_group_id
LEFT OUTER JOIN PRODUCT_CATEGORY D on A.product_category_id =
D.product_category_id
LEFT OUTER JOIN PRODUCT_SUB_CATEGORY E on A.product_sub_category_id =
E.product_sub_category_id
LEFT OUTER JOIN PRODUCT F on A.product_id = F.product_id
order by A.product_group_id, A.product_category_id,
A.product_sub_category_id, A.product_id
</CFQUERY>

Anyone have any idea why this would be happening? I ran the SQL query in SQL
Manager and it runs fine. Any help would be greatly appreciated =)

[MikerRoo]

Most likely, the database was moved/upgraded too.

In SQL Server, Enterprise Manager, change the login that is used by your data
source -- set the default database to the one that contains PRODUCT_HIERARCHY.

Or you can rewrite your code to fully qualify all SQL objects -- for example,
the following code probably works right now (fill in the correct value for
"YOUR_DATA_BASE_NAME"):
<CFQUERY NAME="getHierarchy" DATASOURCE="DRSWEB">
SELECT *
FROM [YOUR_DATA_BASE_NAME].dbo.PRODUCT_HIERARCHY
</CFQUERY>

Cheers,
-- MikeR