ArcGIS Pro SDK C#: Create a Database Connection

JadedEarth

I was just going to leave this as a minor thing, but it's getting really cumbersome.  When I use the geoprocessing tool, "CreateDatabaseConnection_management", to create an SDE connection in my Add-In app, the connected SDE geodatabase is populated with "randomly-assigned" tables, instead of the actual tables contained in the database. 

Running the tool in the Geoprocessing tab, however, the SDE database connection is populated with correct tables.  Is this a bug in the SDK?  Below is my code snippet:

 

 

//Create a new sde connection
try
{  
    ProgressDialog progDlg = new ProgressDialog("Creating Database Connection...", "Cancel", 100, true);
    progDlg.Show();

    //Execute a GP tool
    IReadOnlyCollection<string> args = Geoprocessing.MakeValueArray(workDir, connName, server, instance, "OPERATING_SYSTEM_AUTH", dbName, sdePath);
    IGPResult gp_result = await Geoprocessing.ExecuteToolAsync("CreateDatabaseConnection_management", Geoprocessing.MakeValueArray(args.ToArray()),
                                                null, new CancelableProgressorSource(progDlg).Progressor, GPExecuteToolFlags.Default);
    }
catch (Exception ex)
{
	ArcGIS.Desktop.Framework.Dialogs.MessageBox.Show("Failed to create database connection: " + ex.Message, "Error Message", MessageBoxButton.OK, MessageBoxImage.Error);
}

KimberlyGarbade

Hmmm... so no matter what the user chooses (like if  they type or choose "GIS_TMP") they are initially connected to the "CEAP_Routed_Output" database instead... 

Here is a post that addresses a similar situation. 

https://community.esri.com/t5/python-questions/python-script-using-arcpy-createdatabaseconnection/td-p/159152

I think it is saying that you have to fully quality the inputs your putting in your MakeValueArray.  For example rather than populating the array with SQL_SERVER you would use database_platform="SQL_SERVER".  I think the post is suggesting that since the optional inputs into the CreateDatabaseConnection_management function are being left blank, python needs the fully qualified inputs to know which array values are used to populate which parameters of the function.  Sounds just crazy enough to work.

The only other thing I can think of is that when your using the function from the app it isn't overwriting a current connection file having the same name as the one you are creating; and that existing file is pointed at "CEAP_Routed_Output".  You might try setting overwriteoutput to true in your script or deleting any existing connection file with the same name in the same folder before creating the new one.