Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I want to have a geoprocessing service update sde. I am getting an I/O Error saying data doesn't exist. I imagine because the connection file (copied from my ArcCatalog folder) I placed next to the script isn't working through digital osmosis.

I found an answer on GIS.se outlining some steps to have a geoprocessing service write to sde. I have successfully hit sde with desktop script tools.

Do I need to log on to the server as the arcgissoc user and build database connections? Is there any documentation?

share|improve this question
add comment

1 Answer

You need a GP service on the server and the SDE connection needs to be on the server, as well. The script that the tool in the GP Service uses will need to be told where to find the SDE conn file i.e. \\servername\folder\folder\your_sde_connection_file.sde\SDEfeatureclass

Assuming you are a user with permission to be on the server. I would not use the SOC account.

Here is greater detail on connecting to the server Use AC on your PC to make a connection to the server (use AC "Connect to Folder" to make the server connection under Folder Connections) you'll need to find your location/make a folder. Add the scripts and a SDE connection file to this folder that you will copy/paste from AC Database Connections. Create the toolbox here. In AC section of GIS Servers (you may need to add yours) right click the server and "Add Service". Use the toolbox from your Folder Connections for your new GP service.

share|improve this answer
    
So is there an arcpy method that builds a connection? –  Justin Mar 29 '12 at 20:06
    
I don't have ArcCatalog on the same server where ArcGIS Server sits. Or at least I can't find it. –  Justin Apr 2 '12 at 13:34
    
Nice answer. I encourage you to fold the extended procedure in the comments into the answer itself, so it's cohesive and all in one place. (see the edit link in light grey at bottom left of the post). –  matt wilkie Apr 19 '12 at 17:27
    
Thank you. I did edit the answer with my comments, and deleted the comments. –  JLP Wisc. Apr 20 '12 at 19:31
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.