Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SQL table not refreshing from Server but will in Desktop

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

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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