>
> We just upgraded our dev server to MX 6.1 and also have a new SQL
> Server 2K machine that I just exported all of our tables to. I'm getting
> the following error:
>
> Error Executing Database Query.
> [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name
> 'tbl_Product_Main_LU'.
>
> The error occurred in
> C:\CFusionMX\wwwroot\hittite\global_files\left_nav.cfm: line 16
> Called from C:\CFusionMX\wwwroot\hittite\index.cfm: line 127
> Called from C:\CFusionMX\wwwroot\hittite\global_files\left_nav.cfm: line
> 16
> Called from C:\CFusionMX\wwwroot\hittite\index.cfm: line 127
>
> 14 : AND tbl_Product_Main_LU.replace_eff_date IS NULL
>
> 15 : OR tbl_Product_Main_LU.tbl_Product_Category_ID =
> tbl_Product_Category.Product_CategoryID
> 16 : AND tbl_Product_Main_LU.replace_eff_date >=
> #Now()#
> 17 : AND int_Hide_Item = 0
> 18 : ORDER BY tbl_Product_Main_LU.Part_Number
>
>
>
> The odd thing is that on line 16 where the error is coming from, the
> table that it's choking on is being called in several lines ahead of it
> and doesn't seem to have a problem.
That is probably just an optimizer issue.
> Anyone have this type of thing happen before?
Make sure that the user you are using has permissions to the table.
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
