topic export a feature class to .shp - unable to connect to sql server with python in Python Questions

export a feature class to .shp - unable to connect to sql server with python

BobNoyes — Tue, 14 Sep 2021 17:11:30 GMT

I am trying to upgrade a script I use in ArcMap to ArcGIS Pro. I am not able to get it to recognize the the path to our sql server which houses the feature class I want to access. The script work fine in ArcGIS Map but I get errors when trying in ArcGIS Pro.

This is a script that will have multiple lines but the first step is creating problems. Also, I ran the export tool on the feature class in pro and it worked fine. I then copied the snippet from the results and pasted it into the script (using PyCharm).

Here is the script as it stands so far:

import arcpy

try:
    in_table = r'Database Connections\GIS Update.sde\GIS_update.dbo.Orion_Taxlots\GIS_update.dbo.Orion_Taxlots'
    in_data = r'Database Connections\JOCO B Marial.sde\jocoB_Production.DBO.POLY\jocoB_Production.DBO.poly_gon'
    out_path = r"C:\GIS\Substage"
    out_shp = "jocoB_Production_DBO_poly_gon.shp"
    TL = r"C:\GIS\Substage\jocoB_Production_DBO_poly_gon.shp"
    Out_Taxlots = "C:\\GIS\\Substage\\Taxlots.shp"

    # Step 1 jocoB poly_gon copied to C:\GIS\Substage
    arcpy.FeatureClassToShapefile_conversion(in_data, out_path)
    print("Step 1 complete")

    # Step 2   Dissolve TL.shp on MNX as Taxlots.shp
    arcpy.Dissolve_management(in_features=TL, out_feature_class=Out_Taxlots, dissolve_field="MNX",statistics_fields="#", multi_part="MULTI_PART", unsplit_lines="DISSOLVE_LINES")

    print("Step 2 complete: dissolved TL.shp on MNX, save as Taxlots.shp")
except Exception as e:
    print("Error: " + e.args[0])

Re: export a feature class to .shp - unable to connect to sql server with python

MichaelVolz — Tue, 14 Sep 2021 17:23:04 GMT

I would make sure you are using the correct connection for Pro (In Oracle ats least you needed to use a 64-bit client instead of a 32-bit client).

I would use the actual path to the database connection c:\... instead of shorthand path which definitely works in ArcMap but I do not thinks works with Pro due to its different architecture.

in_table = r'Database Connections\GIS Update.sde\GIS_update.dbo.Orion_Taxlots\GIS_update.dbo.Orion_Taxlots'

Re: export a feature class to .shp - unable to connect to sql server with python

BobNoyes — Tue, 14 Sep 2021 17:30:01 GMT

Thanks. We are using Microsoft sql server and its at 64 bit. I am not sure what you mean when you say the actual path and use the C:\ drive prompt. This is not something I have ran across before. In the past it was as easy as copying and pasting the path from ArcCatalog..... Thanks again.