Invalid object name - local to network server

[jennypretty]

Hello friends,
I tried to move a cf page from local to network server and it generates an error like below:
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'COTR_POCS'.

Do I have to change the DSN for the query?
This is my query: <CFQUERY name="poc" datasource="jennyDSN">

Thanks,
Jenny.

 

[jennypretty]

I also tried this:
<CFQUERY name="poc" datasource="#Application.dsn#" >
I got a different error:
The requested scope application has not been enabled.
Before application variables can be used, the application state management system must be enabled using the CFAPPLICATION tag.

Please help.
Jenny.