topic Re: python script using arcpy.CreateDatabaseConnection_management creates a connection to the wrong geodatabase. in Python Questions

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

JuliePaine — Thu, 18 Sep 2014 18:23:05 GMT

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?

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

ChristianWells — Thu, 18 Sep 2014 20:50:21 GMT

Hi Julie, I don't see the script attached to this message, can you post it again?

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

JuliePaine — Thu, 18 Sep 2014 20:55:59 GMT

Here's the 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("Database Connections",
                                          "GIS winauth to gis-server.sde",
                                          "SQL_SERVER",
                                          "gis-server",
                                          "OPERATING_SYSTEM_AUTH",
                                          "GIS",
                                          "TRANSACTIONAL"
                                          "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

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

ChristianWells — Thu, 18 Sep 2014 21:16:36 GMT

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()

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

JuliePaine — Thu, 18 Sep 2014 21:22:30 GMT

Thank You! That did the trick!

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

RemiAmbattakathutt — Thu, 26 Mar 2015 09:34:48 GMT

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 FEFAULT version. Could you please provide any input on this? Here is the code i used

arcpy.CreateDatabaseConnection_management(out_folder_path="Database Connections",

out_name="creaconn5.sde",

database_platform="ORACLE",

instance="srv1/testgis",

account_authentication="DATABASE_AUTH",

username="sde",

password="xxxx",

save_user_pass="SAVE_USERNAME",

version_type="TRANSACTIONAL",

version="TEST.VERSION1")

In the immediate window right pane it shows as

Executing: CreateDatabaseConnection "Database Connections" creaconn5.sde ORACLE srv1/testgis DATABASE_AUTH sde ***** SAVE_USERNAME # SDE TRANSACTIONAL # #

You can observe that, even though I specified version parameter, it took it as blank (#)