issue creating new sde connection files with arcpy

RuthEmerick — Wed, 23 Mar 2011 19:22:36 GMT

I've been creating new sde connection files in python (IDLE) just fine using the following code:

import arcpy
SDEPath = "Database Connections"
SDEName = "Connection to myservername.sde"
serverName = "myservername"
serviceName = "5151"
databaseName = "mydatabasename"
authType = "OPERATING_SYSTEM_AUTH"
arcpy.CreateArcSDEConnectionFile_management(SDEPath , SDEName, serverName, serviceName, databaseName, authType)

These connections work just fine, they show up in ArcCatalog, etc. When I attempt to use the same code in the ArcGIS python interpreter, I get the following error and no connection is created:

Runtime error <class 'arcgisscripting.ExecuteError'>: Failed to execute. Parameters are not valid. ERROR 000840: The value is not a Encrypted String. Failed to execute (CreateArcSDEConnectionFile).

I get the same thing when I set

SDEPath = r"C:\myworkspace"

or any other literal path string.

Anyone have an idea of what is going on here?

Re: issue creating new sde connection files with arcpy

Anonymous User — Mon, 28 Mar 2011 14:31:20 GMT

I would try

SDEPath = r"C:\\myworkspace"

or

SDEPath = r"C:/myworkspace"

either should work.

topic issue creating new sde connection files with arcpy in Python Questions

issue creating new sde connection files with arcpy

Re: issue creating new sde connection files with arcpy