Conecctor

[Luisanabria]

Hi again all,

The company where l work now, have a model, wich has a connection to a sql server until 2020, now l want to update that information, but the database change, so l try replacing only the "LIB CONECT TO X" and name in my FROM:

Example:

FROM database.dbo.tableX

But this error appears:

So is possible to do what l try or should l have to do all again?

Thanks 

[Vicky_Z]

If the DB only have name changed, I won't start from scratch. 

The code "42S22" indicates the error is generated from DB side. I find this Microsoft article and you may check if your scenario fits: 

https://support.microsoft.com/en-us/topic/kb2889987-fix-invalid-column-name-columnname-error-when-yo...