topic Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc in ArcGIS Enterprise Questions

Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

IvanHuilca — Thu, 13 Nov 2014 17:20:48 GMT

I have a scipt in Python 2.7 with the library pyodbc published as geoprocessing tool in ArcGIS Server 10.2, when running I get fatal error: import pyodbc import error: no module named pyodbc. The tool executes smoothly from ArcMap and Python IDLE. any suggestions?

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

BlakeTerhune — Fri, 26 Dec 2014 15:50:48 GMT

Make sure everything is the same 32-bit or 64-bit version.

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

XanderBakker — Fri, 10 Dec 2021 21:27:15 GMT

Hi Ivan,

Are you sure pyodbc is available and accessible to the server?

I do have a few comments about the code itself. There are so many int-str conversions, it makes my head spin...

When reading the rows, if "Input_Sct", "Input_Ruta" and "Input_Secu" are values (integers), use this:

    Input_Sct = "%03d" % (Input_Sct,)
    Input_Ruta = "%04d" % (Input_Ruta,)
    Input_Secu = "%05d" % (Input_Secu,)

If they are strings (or numbers), do this to format them:

    Input_Sct ="{0}".format(Input_Sct).zfill(3)
    Input_Ruta ="{0}".format(Input_Ruta).zfill(4)
    Input_Secu ="{0}".format(Input_Secu).zfill(5)

Read more on formating, here: Some Python Snippets

To concatenate a string, it is better to use the format method on a string. It makes it a lot more easy to read.

To get the number if items in a list, just use:

contlist = len(lista_Ubica)

To create the where clause you could use something like this:

fldname = "clave2"
fc = "Clientes"
where = "{0} IN ('{1}')".format(arcpy.AddFieldDelimiters(fc, fldname), "','".join(lista_Ubica))

This will create a where clause with the following syntax:

clave2 IN ('123','abc','kjsjhadas')

At the end of your script you use arcpy.da.SearchCursor to get a count. Why? I think the result is the same as the arcpy.GetCount_management you perform just before...

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

IvanHuilca — Mon, 12 Jan 2015 17:00:26 GMT

Such xander_bakker.
Thank you very much for your kind response, I will consider your suggestions on the concatenation of string, but as you can check in my posting the error is in the pyodbc that ArcGis server does not recognize, it is installed the 64 bit version.

Thank You

Ivan

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

IvanHuilca — Mon, 12 Jan 2015 17:01:10 GMT

Such Blake T.
it is installed the 64 bit version.

Thank You

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

NickHetrick — Mon, 12 Jan 2015 17:54:44 GMT

Yup you will most likely need the 64bit version of pyodbc. Also I noticed you are using a DSN to access your database. You should also make sure that you have the DSN setup in the correct ODBC manager on your windows server. Most likely if you are using 64bit it should be in the 64bit manager

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

XanderBakker — Mon, 12 Jan 2015 17:55:43 GMT

ArcGIS 10.2 uses 32 bits...

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

NickHetrick — Mon, 12 Jan 2015 18:13:21 GMT

Incorrect ArcGIS server is a 64bit application now since 10.2. Desktop is 32.

System Requirements

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

IvanHuilca — Mon, 12 Jan 2015 21:04:05 GMT

thanks for your answers, exactly 10.2 ArcGis server uses 64 bits

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

IvanHuilca — Thu, 15 Jan 2015 20:50:13 GMT

That such.
We check the DSN connection and it works, I could query the data from Excel, including the tool can be run locally from ArcCatlog and allows me to issue you ArcGis Server as you can see in the attached image, the problem I think is that ArcGIS Server not recognizes the pyodbc library.

Thanks for your feedback

Ivan

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

IvanHuilca — Mon, 19 Jan 2015 20:46:23 GMT

Dear friends many grace for your help.

Today I was told through the ESRI support, this error will be solved for the next version of ArcGIS Server 10.2. Meanwhile I'll try through an OLE DB connection created in ArcCatalog.

Re: Fatal error when running ArcGIS Server 10.2 tool, created in Python 2.7 with pyodbc

NickHetrick — Tue, 20 Jan 2015 16:22:22 GMT

Good to know. Did you mean the next version of 10.3?