POST
|
Did you get a resolution to this? I've looking for the same functionality (AGS passing the users creds to the backend SQL Server). Thanks
... View more
09-29-2014
09:11 AM
|
0
|
1
|
513
|
POST
|
I have a simple script that exports a map to a JPEG. Here is the meat of it:
print "generating ouput of " + mxdPath
mxd = arcpy.mapping.MapDocument(mxdPath)
arcpy.mapping.ExportToJPEG(mxd, outputPath, 'PAGE_LAYOUT',1024,1024) Pretty easy. Problem is there is a ton of SDE Connections, that in turn throw a "Spatial Connection Dialog" that stalls the script. I found a blog or a forum post that said if I use the "CreateArcSDEConnectionFile_management" GP to create the .sde files before I tried exporting the jpeg, I wouldn't get the Spatial Connection Dialog. Seemed to work ok but the problem is every time I run this script i need to create some 10 .sde connection files for the different SDE servers.
# create temporary connection files in memory
print "create ArcSDE Connection files"
try:
print 'created'
arcpy.AddMessage('create connections')
arcpy.CreateArcSDEConnectionFile_management( sdeConnectionFolder, "Connection1", "Server1", "5161", "", "DATABASE_AUTH", "[USERNAME]", "[password]", "SAVE_USERNAME", "SDE.DEFAULT", "SAVE_VERSION")
arcpy.CreateArcSDEConnectionFile_management( sdeConnectionFolder, "Connection2", "Server2", "5161", "", "DATABASE_AUTH", "[USERNAME]", "[password]", "SAVE_USERNAME", "SDE.DEFAULT", "SAVE_VERSION")
arcpy.CreateArcSDEConnectionFile_management( sdeConnectionFolder, "Connection3", "Server3", "5161", "", "DATABASE_AUTH", "[USERNAME]", "[password]", "SAVE_USERNAME", "SDE.DEFAULT", "SAVE_VERSION")
arcpy.CreateArcSDEConnectionFile_management( sdeConnectionFolder, "Connection4", "Server4", "5161", "", "DATABASE_AUTH", "[USERNAME]", "[password]", "SAVE_USERNAME", "SDE.DEFAULT", "SAVE_VERSION")
arcpy.CreateArcSDEConnectionFile_management( sdeConnectionFolder, "Connection5", "Server5", "5161", "", "DATABASE_AUTH", "[USERNAME]", "[password]", "SAVE_USERNAME", "SDE.DEFAULT", "SAVE_VERSION")
arcpy.CreateArcSDEConnectionFile_management( sdeConnectionFolder, "Connection6", "Server6", "5161", "", "DATABASE_AUTH", "[USERNAME]", "[password]", "SAVE_USERNAME", "SDE.DEFAULT", "SAVE_VERSION")
arcpy.CreateArcSDEConnectionFile_management( sdeConnectionFolder, "Connection7", "Server7", "5161", "", "DATABASE_AUTH", "[USERNAME]", "[password]", "SAVE_USERNAME", "SDE.DEFAULT", "SAVE_VERSION")
arcpy.CreateArcSDEConnectionFile_management( sdeConnectionFolder, "Connection8", "Server8", "5161", "", "DATABASE_AUTH", "[USERNAME]", "[password]", "SAVE_USERNAME", "SDE.DEFAULT", "SAVE_VERSION")
arcpy.CreateArcSDEConnectionFile_management( sdeConnectionFolder, "Connection9", "Server9", "5161", "", "DATABASE_AUTH", "[USERNAME]", "[password]", "SAVE_USERNAME", "SDE.DEFAULT", "SAVE_VERSION")
except Exception as e:
print e.message
# If using this code within a script tool, AddError can be used to return messages
# back to a script tool. If not, AddError will have no effect.
arcpy.AddError(e.message)
print "generating ouput of " + mxdPath
mxd = arcpy.mapping.MapDocument(mxdPath)
arcpy.mapping.ExportToJPEG(mxd, outputPath, 'PAGE_LAYOUT',1024,1024)
This works OK, but is slow when I run through 100 maps as I have to run them one at a time. Is there a better way to do this? Is there a way for me to create these .sde connection files, and in the script somehow reference them? Cheers
... View more
05-15-2012
09:42 AM
|
0
|
0
|
582
|
POST
|
I'm migrating a standalone VB.NET program from ArcGIS 9.3.1 to 10. In the program the AppROT class is used to scan what ArcGIS applications are opened & fire the application remove or add. It works fine in 9.3.1 but in ArcGIS 10 the Dim pAppRot As AppROT = New AppROT statement throw this error: Retrieving the COM class factory for component with CLSID {FABC30FB-D273-11D2-9F36-00C04F6BC61A} failed due to the following error: 80040111. I read in the ArcObject SDK Help / How to migrate ArcGIS 9.3 Desktop and Engine stand-alone applications to ArcGIS 10, that: 'Insert this line before the InitializeComponent() method in Public Sub New(). ESRI.ArcGIS.RuntimeManager.Bind(ESRI.ArcGIS.ProductCode.Engine) I inserted this line and the program worked in debug mode, but running the program the previous error was thrown at the same statement. Is there any idea to solve this problem? Did you resolve this issue? I am having the same problem. Cheers
... View more
09-02-2011
08:44 AM
|
0
|
0
|
247
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|