SQL table not refreshing from Server but will in Desktop

[Anonymous]

Hi, 

I have a imported table (direct, no custom SQL) in desktop that refreshes fine. However when published to the Server and with the gateway set, this table kills the dataset refresh with the error "The name 'XXXX' wasn't recognized. Make sure it's spelled correctly.. The exception was raised by the IDbCommand"

The table was recently re-purposed and re-named, but this was done before the table was added to my dataset in desktop. 

Any ideas are welcome.

Thanks, 

Mark

[Anonymous]

Hi @Anonymous ,

What type of changes are you applied on your table, any dynamic changes or security settings enabled on your table structure?

Can you please share more detail information to help us clarify your scenario?

How to Get Your Question Answered Quickly  

Regards,
Xiaoxin Sheng