python script using arcpy.CreateDatabaseConnection_management creates a connection to the wrong geodatabase.

JuliePaine

I'm using SQL Server 2008 R2, sde v10 geodatabases, and Desktop v10.2.2.

'PublicWorks'  geodatabase exists in the sde schema, 'GIS' geodatabase in the dbo schema. Running the following script establishes a connection to 'PublicWorks' instead of 'GIS'.

Using the tool in ArcToolbox establishes the connection correctly to the GIS db.

Why is the attached script not connecting to the GIS geodatabase?

Christian_Wells

Hi Julie, can you try the following script:

#create a new sde connection

#List all featureclasses in a geodatabase, including any within feature datasets

import arcpy,os

from arcpy import env

arcpy.env.overwriteOutput = True

arcpy.CreateDatabaseConnection_management(out_folder_path="Database Connections",

                                          out_name="GIS winauth to gis-server.sde",

                                          database_platform="SQL_SERVER",

                                          instance="gis-server",

                                          account_authentication="OPERATING_SYSTEM_AUTH",

                                          database="GIS",

                                          version_type="TRANSACTIONAL",

                                          version="dbo.DEFAULT")

arcpy.env.workspace = r"Database Connections\GIS winauth to gis-server.sde"

datasets = arcpy.ListDatasets(feature_type='feature')

datasets = [''] + datasets if datasets is not None else []

for ds in datasets:

    for fc in arcpy.ListFeatureClasses(feature_dataset=ds):

        path = os.path.join(arcpy.env.workspace, ds, fc)

        print path

I believe the problem with the previous script was that the parameters were looking for the data in the following order:

(out_folder_path, out_name, database_platform, instance, {account_authentication}, {username}, {password}, {save_user_pass}, {database}, {schema}, {version_type}, {version}, {date})

Although they are optional parameters, arcpy is expecting a variable there. So another way to complete this is to specify the dictionary parameters for arcpy.CreateDatabaseConnection_management()