topic Re: SDE Connection error in Python Questions

SDE Connection error

DianeBird — Tue, 10 Sep 2013 02:29:22 GMT

We are trying to run a python script on the server on a feature class within an SDE database.
The error code reads: ERROR 000732: Input Features: Dataset does not exist or is not supported.

import arcpy, csv, os
import arcpy._mapping
import arcpy.da

arcpy.env.workspace = "Database Connections\\ARC1_SQLExpress(2).sde"
theDBfile = "L3_Edits.DBO.L3_Lines"
fcoutput = "L3_Edits.DBO.L3_verts"
arcpy.FeatureVerticesToPoints_management(theDBfile,fcoutput,"ALL")

We are running ARC 10.2; Windows Server 2008 R2.
Our SDE connection is missing something... None of the examples we have seen have shown anything else workable.
Any suggestions?

Re: SDE Connection error

MathewCoyle — Tue, 10 Sep 2013 12:13:25 GMT

Can you post all your code? Are you sure the connection file exists in that location? Are you attempting to run this as a service/task while not logged in?

Also, please read this on posting code.
http://forums.arcgis.com/threads/48475-Please-read-How-to-post-Python-code

Re: SDE Connection error

DianeBird — Tue, 10 Sep 2013 14:08:42 GMT

Can you post all your code? Are you sure the connection file exists in that location? Are you attempting to run this as a service/task while not logged in?

Also, please read this on posting code.
http://forums.arcgis.com/threads/48475-Please-read-How-to-post-Python-code

Thank you for your comments and link.
The connection is what we see in Catalog under "Database Connections". Should we be looking under "Database Servers"?
This code is the beginning of a conversion of programs written and working for shapefiles.
We are just learning Python and trying to figure out how to connect to our SDE database.

Re: SDE Connection error

MathewCoyle — Tue, 10 Sep 2013 14:37:40 GMT

Your "Database Connections" folder is user specific ("%APPDATA%\ESRI\Desktop10.1\ArcCatalog"). When dealing with servers it is best to store them in a location all users can access. Otherwise you will run into issues if another user or the system attempts to execute the script they won't be able to find that location.

Re: SDE Connection error

DianeBird — Tue, 10 Sep 2013 15:10:53 GMT

Ah haa! Thank you.
That was the bit of information we needed. We copied the connection file to a C:\Data folder and it worked.

arcpy.env.workspace = "C:\\Data\\Connection to ARC1_SQLExpress (2).sde"

Thanks again!