antonypaulm

Layer file Join issue with SQL server view

Discussion created by antonypaulm on Feb 25, 2013
Latest reply on Feb 27, 2013 by mvolz47
Hi All,

I am having a layer file which I am trying to join with SQL server view. The idea is to get the customer more atribute information.

The layer file is ArcSDE 9.3 / Oracle
SQL server 2005
Desktop 10.1

When I validate join I am getting the following error from ArcMAp

"Field names containing invalid characters can cause the join to fail, the following fields containing invalid characters:
- [start Date from<dbo.tableForLayerFiles> Contains invalid character ' '
- [start Date  / Duration ]from<dbo.tableForLayerFiles> Contains invalid character ' /'
- [start Date  / Duration ]from<dbo.tableForLayerFiles> Contains invalid character '  '


What date format 10.1 desktop is expecting here? Can anyone adcvice me on this?

The same layer file join with SQL server view worksfine in 9.3 and in defenition query I have given io_P_area.OBJECTTID > 0 and  "Start Date" > date '30-01-2012', This works in desktop 9.3 environment

Please help

Cheers
Antony

Outcomes