"No Editable Layers" when editing DBMS table/view in ArcMap

[KenBurcham]

Hi,

  We have a number of databases in addition to our sde geodatabase and we often create a connection to and pull in these non-sde tables and views and use the data as layers, etc.  It seems that we're unable to edit these tables through ArcMap.  When we try we get the error "no editable layers".  These tables are editable by the same user using SQL tools, so permissions are fine. 

  I guess my question is this:  Can ArcMap edit non-SDE tables from other databases?  It seems like it should be able to, but just isn't.  Maybe there is something I'm missing?  I've read docs and surfed the forums but coming up empty.

Thanks!

ken.

[KenBurcham]

*bump*

any thoughts on this?

thanks,

ken.

[RichardFairhurst]

Hi,

  We have a number of databases in addition to our sde geodatabase and we often create a connection to and pull in these non-sde tables and views and use the data as layers, etc.  It seems that we're unable to edit these tables through ArcMap.  When we try we get the error "no editable layers".  These tables are editable by the same user using SQL tools, so permissions are fine. 

  I guess my question is this:  Can ArcMap edit non-SDE tables from other databases?  It seems like it should be able to, but just isn't.  Maybe there is something I'm missing?  I've read docs and surfed the forums but coming up empty.

Thanks!

ken.

What are the other databases you are connecting to?  What kind of connection are you creating (ODBC or what)?  Sometimes drivers are more oriented to viewing data than to supporting full editing capabiliies, so the specifics probably matter.

[KenBurcham]

We're connecting to MS SQL Server 2012 using the native driver. 

For example, I can connect to our "FisheriesSurveyData" database (using sa user, just to rule out permissions) and drag in a table called "Redds".  It adds the layer to my ArcMap called: "FisheriesSurveyData.DBO.%Redds" (not sure why it adds the % sign to the name...).  When I go to the properties and click the source tab, here's the information:

Data Type: Standalone Table
Table Type: Query Table
Server: GIS-SQL01
Client: sqlserver
Connection Properties: GIS-SQL01
Database: FisheriesSurveyData
User name: sa
Has Object-ID Field: Yes


It seems that "Standalone Table" should allow editing, yes? 

The ObjectID that I select for the unique id field is a Long Integer, not an ObjectID type...  But I don't think that matters.

When I right click the table layer and choose Edit Features -> Start Editing, I get this error:

[ATTACH=CONFIG]21679[/ATTACH]

[KenBurcham]

I hate to *bump* this again...  🙂  but any more ideas out there?

[jodavies]

Did you resolve this, I'm seeing this issue too and can't find any helpful info about it apart from this thread!

[KenBurcham]

After all the stuff we tried and researched, it seems that editing foreign table data in ArcGIS Desktop is not supported in 10.1.  I read somewhere that it might be supported in 10.2. 

I did find that if I create the database table from ArcGIS desktop I can edit it.  I can also (and don't try this at home) add the table manually to the geodatabase metadata that tracks tables then I could edit it.  But since that would be a very unsupported scenario, we didn't want to go down that road. 

So we're solving our editing via a web application.

Hope that helps!

ken.