Ask the Experts - 82
Can we create a View in App Designer, which accesses tables from another link server?
the owner “dbo” should be in lowercase only.
SQL error. Stmt #: 2675 Error Position: 0 Return: 8601 – [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ‘NOUPPERCASE’.
When I dont use %NoUpperCase, it automatically casts as “.DBO.”(so gives an invalid object error)
I am using PT 8.42 version.
Please suggest a solution.
Thanks for posting your question!
§ Don’t build the view from Application designer, instead generate SQL from Application designer and explicitly run it in the SQL editor. From SQL Editor create view and SQL Server will verify the syntax too.
§ Alternatively consider using SYNONYM