using _mssql functions from python 3.6 and 3.7

[ChristophR]

Hi, i am newly connected to this group.

i have a question about using the _mssql functions.

i have used import _mssql in a database connection function used by a lot of other python functions. Those functions are called from a server (automation) and from clients (developer).

The python version is connected to ArcGIS Software.

The server (ArcGIS Server) has python version 3.6.10 and the clients were migrated via ArcGIS Pro Update from 3.6.10 to 3.7.10. So on the clients i updated the pymssql version from 2.1.4 to  2.2.2.

But still the message "No module named '_mssql' was logged while running scripts using this function from clients.

I read then that the import call changed in version 2.2.0 from import _mssql to from pymssql import _mssql.

So i wanted to install a pymssql 2.2.2 version for python 3.6 win 64-bit on the server, but i didn't found a version (and i cannot changed the python version on clients or server).

Do you have an idea how to use one function using _mssql functions from machines using python versions 3.6.10 (server) and 3.7.10 (client).

Regards Christoph