topic Re: how to connect to SDE version using stand alone python script in Python Questions https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430240#M33815 <HTML><HEAD></HEAD><BODY><P>Jake, do you know</P><P>How&nbsp; to start, stop and save edits in python script for arcmap version 10.0.</P><P>arcpy.da.editing is working for arcmap 10.1 version onwards</P></BODY></HTML> Fri, 19 Dec 2014 09:44:23 GMT TarunPunetha1 2014-12-19T09:44:23Z how to connect to SDE version using stand alone python script https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430237#M33812 <HTML><HEAD></HEAD><BODY><P>How to connect a argis, sde version through stand alone python script. SDE.Mapping is child version of SDE.Default and I want to make child version of SDE.Mapping . I am using direct sde services, sde:oracle11g:dbname</P><P>I need to know command of python to connect to a sde version.</P><P><IMG alt="session connection.JPG" class="jive-image image-1" src="/legacyfs/online/35280_session connection.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 28 Nov 2014 12:18:06 GMT https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430237#M33812 TarunPunetha1 2014-11-28T12:18:06Z Re: how to connect to SDE version using stand alone python script https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430238#M33813 <HTML><HEAD></HEAD><BODY><P>Hi Tarun,</P><P></P><P>You can do this using the <A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000016q000000">Create Database Connection</A> tool.&nbsp; There is an optional parameter, version, where you can specify the database version.&nbsp; Ex:</P><P></P><PRE __default_attr="python" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14174354069588935 jive_text_macro" jivemacro_uid="_14174354069588935"><P>arcpy.CreateDatabaseConnection_management("Database Connections", "ORCL", "ORACLE", "SDESERVER", "DATABASE_AUTH", "vector", "vector", "SAVE_USERNAME", "#", "#", "TRANSACTIONAL", "VECTOR.Child1")</P></PRE></BODY></HTML> Mon, 01 Dec 2014 12:03:37 GMT https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430238#M33813 JakeSkinner 2014-12-01T12:03:37Z Re: how to connect to SDE version using stand alone python script https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430239#M33814 <HTML><HEAD></HEAD><BODY><P>Thanks Jake, it worked</P></BODY></HTML> Fri, 19 Dec 2014 09:43:25 GMT https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430239#M33814 TarunPunetha1 2014-12-19T09:43:25Z Re: how to connect to SDE version using stand alone python script https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430240#M33815 <HTML><HEAD></HEAD><BODY><P>Jake, do you know</P><P>How&nbsp; to start, stop and save edits in python script for arcmap version 10.0.</P><P>arcpy.da.editing is working for arcmap 10.1 version onwards</P></BODY></HTML> Fri, 19 Dec 2014 09:44:23 GMT https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430240#M33815 TarunPunetha1 2014-12-19T09:44:23Z Re: how to connect to SDE version using stand alone python script https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430241#M33816 <HTML><HEAD></HEAD><BODY><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">Jake,</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;"></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">I am having a similar issue. I am trying to connect to a version other than DEFAULT by providing version parameter. But it is always connecting to DEFAULT version. Could you please provide any input on this? Here is the code i used</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">arcpy.CreateDatabaseConnection_management(out_folder_path="Database Connections",</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out_name="creaconn5.sde",</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; database_platform="ORACLE",</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; instance="srv1/testgis",</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; account_authentication="DATABASE_AUTH",</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; username="sde",</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; password="xxxx",</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; save_user_pass="SAVE_USERNAME",</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; version_type="TRANSACTIONAL",</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; version="TEST.VERSION1")</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">In the immediate window right pane it shows as</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">Executing: CreateDatabaseConnection "Database Connections" creaconn5.sde ORACLE srv1/testgis DATABASE_AUTH sde ***** SAVE_USERNAME # SDE TRANSACTIONAL # #</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">You can observe that, even though I specified version parameter, it took it as blank (#)</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;"></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">Could you help in identifying what went wrong?</P></BODY></HTML> Thu, 26 Mar 2015 09:41:05 GMT https://community.esri.com/t5/python-questions/how-to-connect-to-sde-version-using-stand-alone/m-p/430241#M33816 RemiAmbattakathutt 2015-03-26T09:41:05Z