I am trying to make edits from a python script using a temporary database connection, I am certain that my parameters are correct however I am consistently receiving RuntimeError: cannot open workspace I am generating an .sde file output but I suspect something is wrong since my script cannot open the workspace.
import arcpy import os fil = "DBTempConnect" + GetDateTimeString(12) filSde = "DBTempConnect" + GetDateTimeString(12)+ ".sde" wS = os.path.join(r'E:\C_Drive_files\Administrator\311Request',filSde) arcpy.CreateDatabaseConnection_management(r'E:\C_Drive_files\Administrator\311Request', fil ,"SQL_SERVER","server ","DATABASE_AUTH","auth","pwd","SAVE_USERNAME","ServiceRequest","#","TRANSACTIONAL","#","#") wS = os.path.join(r'E:\C_Drive_files\Administrator\311Request',filSde) edit = arcpy.da.Editor (wS)
أكثر...
import arcpy import os fil = "DBTempConnect" + GetDateTimeString(12) filSde = "DBTempConnect" + GetDateTimeString(12)+ ".sde" wS = os.path.join(r'E:\C_Drive_files\Administrator\311Request',filSde) arcpy.CreateDatabaseConnection_management(r'E:\C_Drive_files\Administrator\311Request', fil ,"SQL_SERVER","server ","DATABASE_AUTH","auth","pwd","SAVE_USERNAME","ServiceRequest","#","TRANSACTIONAL","#","#") wS = os.path.join(r'E:\C_Drive_files\Administrator\311Request',filSde) edit = arcpy.da.Editor (wS)
أكثر...