topic Re: Setting workspace to SDE feature dataset in Python Questions

Setting workspace to SDE feature dataset

KerryAlley — Tue, 12 Mar 2013 13:10:44 GMT

I have a python add-in that successfully edits data in a file .gdb (with or without invoking the editor in the script), but I can't edit data in an SDE feature dataset. I can edit the SDE data (9.3) manually in ArcMap, and the add-in successfully interacts with the SDE data using search cursors. SP1 is installed. Any suggestions about what might be causing the error in response to this code?

workspace = r"Database Connections\GDB_HMSDEV.sde\GDB_HMSDEV.HMSADMIN.KerrySandbox" edit = arcpy.da.Editor(workspace)

Traceback (most recent call last):
File "C:\Users\kalley\AppData\Local\ESRI\Desktop10.1\AssemblyCache\{87D25F75-9A62-5BC9-A006-4B496936EC0F}\ShieldToolTest_addin.py", line 79, in onLine
edit = arcpy.da.Editor(workspace)
RuntimeError: cannot open workspace

I can provide the full code if necessary...just wanted to keep it simple first.

Re: Setting workspace to SDE feature dataset

MichaelVolz — Tue, 12 Mar 2013 17:10:55 GMT

Kerry:

Since you are using ArcGIS v10.1 you might need to specify the full path to the SDE connection and just

r"Database Connections\GDB_HMSDEV.sde\GDB_HMSDEV.HMSADMIN.KerrySandbox"

Re: Setting workspace to SDE feature dataset

JakeSkinner — Sat, 11 Dec 2021 11:55:23 GMT

Hi Kerry,

You won't be able to set the workspace to a feature dataset. It will need to be set only to the sde geodatabase. When you specify a feature class within the feature dataset, just add the feature dataset name first. Ex:

env.workspace = r"Database Connections\SQLSERVER.sde"
desc = arcpy.Describe("Structures\Bridges")

Re: Setting workspace to SDE feature dataset

KerryAlley — Tue, 12 Mar 2013 20:55:23 GMT

Thanks mvolz47!

What you said finally sank into my thick head... and set off a whole cascade of Eureka moments.
I simply changed the workspace (using the .workspacePath of a layer instead of its .dataSource):

workspace = rdsmall_lyr.workspacePath

which was equivalent to the SDE connection path:

workspace = r"C:\Users\kalley\AppData\Roaming\ESRI\Desktop10.1\ArcCatalog\GDB_HMSDEV.sde"

and everything went smoothly!

Thanks again!!

Re: Setting workspace to SDE feature dataset

DanNguyen — Fri, 20 Oct 2017 20:00:06 GMT

If my GIS session is through a Citrix connection, do you know what would be my database connection? I can't seem to get my script to start Edit session.

Any helps will be greatly appreciated.

Thanks