I have some features (Road, Drainage and Parcels - Line, Point and Polygon) data. The spatial attributes of these features are captured by drawing them into arcmap and then stored feature class in a feature dataset in a geodatabase that is on MSSQL2012 database on Server A. The non spatial attributes of these features are existing on another DEVSQL2012 on Server B.
I am able to connect to the different databases using ArcCatalog Database connection and so able to view both the spatial and non-spatial data separately.
I am now trying to create a database View from my ArcCatalog to join the spatial table on Server A to the non-spatial table on Server B. But I keep getting various errors.
Please does anyone has an idea how I can get this resolved.
FROM TVR_CIPS.dbo.Projects INNER JOIN
[DEVSQL2012].TVR_CIPS.dbo.Id = [Frussmolt\TVR3PRD02].PublicWorks.TC_USER.CIP_Point_Only.Project_ID
Here is the error I'm getting
I don't understand why it is seeing that column as invalid. the column is supposed to be a Yes or No (0 and 1) though the field datatype for this column is 'Short integer', Could this be a problem?