Layer file Join issue with SQL server view

AntonyPaul_M1 — Tue, 26 Feb 2013 01:03:01 GMT

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

Re: Layer file Join issue with SQL server view

MichaelVolz — Wed, 27 Feb 2013 16:54:45 GMT

Are the invalid fields coming from the SQL Server database table?

topic Re: Layer file Join issue with SQL server view in ArcGIS Enterprise Questions

Layer file Join issue with SQL server view

Re: Layer file Join issue with SQL server view