topic Script GIS Database Connection in Data Management Questions

Script GIS Database Connection

TedCronin — Mon, 07 Feb 2011 18:20:56 GMT

Is there an ability to script creating a connection to a database, dynamically each time the script runs? I am finding at 10 that my .odc files are getting corrupted (only on Server 2008 R2), so I need to recreate them often, so it would be nice to have a similar capability where I can just script the connection each and every time, then allow it to live only within the time that the script is running, then kill it once the script ends. Ideally, scriptable via python. Can we do this today?

Re: Script GIS Database Connection

RussellBrennan — Tue, 08 Feb 2011 14:14:20 GMT

Hi Ted,

There is no option for creating OLE DB connections through Python. We do have a create ArcSDE connection file tool at 10.

Also, here is a link to an ArcObjects sample that will create an ArcSDE connection file at 9.3/10. With a little bit of tweaking you should be able to get this to work with odc files.
http://blogs.esri.com/Dev/blogs/geoprocessing/archive/2008/09/24/Tips-and-Tricks-_2D00_-Creating-ArcSDE-connection-files-on-the-fly-using-Python-and-ArcObjects.aspx

Unfortunately ArcObjects/Java is not my forte so if you do go this route you may want to post in one of the programming forums for assistance.

Re: Script GIS Database Connection

TedCronin — Tue, 08 Feb 2011 16:53:45 GMT

Perhaps creating .odc files could be an enhancement to finish up this stack, since we can already create .sde connections. Thanks Russell.

I too, see no need to pursue anything outside of python.