topic CreateArcSDEConnectionFile_management and transaction version dbo.DEFAULT selection in Python Questions

CreateArcSDEConnectionFile_management and transaction version dbo.DEFAULT selection

JohnLay — Tue, 25 Sep 2012 10:13:18 GMT

I am trying to make a database connection with the CreateArcSDEConnectionFile_management function in python. Everything works fine EXCEPT that I have to manually change the connection details to dbo.DEFAULT before the connection is usable (I have to do the same even if I am creating the connection through Catalog--Click the Change button in the Connection details section, Choose the dbo.DEFAULT, Click OK on the Connection Details dialog box to close it.)

Is this a known issue?
Is there a work around that can be scripted so that the user does not need to exit the script and manually perform this step?

Re: CreateArcSDEConnectionFile_management and transaction version dbo.DEFAULT selecti

JakeSkinner — Tue, 25 Sep 2012 10:45:47 GMT

Hi John,

Are you specifying the 'version' parameter? Ex:

arcpy.CreateArcSDEConnectionFile_management("C:/Projects","SQLEXPRESS", "SDE_SERVER","sde:sqlserver:SDE_SERVER/sqlexpress","Data","OPERATING_SYSTEM_AUTH","#","#","SAVE_USERNAME","dbo.DEFAULT","SAVE_VERSION")

Re: CreateArcSDEConnectionFile_management and transaction version dbo.DEFAULT selecti

JohnLay — Tue, 25 Sep 2012 11:10:06 GMT

Yep, I am specifying dbo.DEFAULT as the version parameter. Once the database connection is created, I have to manually edit the connection properties and specify dbo.DEFAULT as the version again before it will connect.

[HTML]database = r"Database Connections\CENSUS.sde"
if arcpy.Exists(database):
pass
else:
arcpy.CreateArcSDEConnectionFile_management ("Database Connections", "CENSUS.sde", "CENSUS", "sde:sqlserver:00.00.000.000", "CENSUS", "DATABASE_AUTH", "USER", "PASS", "SAVE_USERNAME", "sde.DEFAULT", "SAVE_VERSION")[/HTML]

Re: CreateArcSDEConnectionFile_management and transaction version dbo.DEFAULT selecti

JakeSkinner — Tue, 25 Sep 2012 11:16:06 GMT

Hi John,

According to the code you posted, you are specifying 'sde.default' (2nd to last parameter). Try changing this to dbo.default.

Re: CreateArcSDEConnectionFile_management and transaction version dbo.DEFAULT selecti

JohnLay — Tue, 25 Sep 2012 11:17:08 GMT

Nope, wait. Looks like I DIDN'T specify dbo.DEFAULT as the version but sde.DEFAULT instead. I should have uploaded the script to begin with.

Thanks Jake for pointing that out.