ActiveGate Extension + PYMSSQL = Error(No module named 'pymssql')

[fernando_albuqu]

Hello,

We are creating an ActiveGate extension that performs queries in MSSQL. However, even having pymssql installed, present in the plugin.json file (in "install_requires"), and being present in the output of the build, even after all this, after the deploy ("plugin_sdk build_plugin") we get the message "Error(No module named 'pymssql')" on Dynatrace UI.

Has anyone ever been through something similar?

Thank you.

Fernando.

[pahofmann]

Is the odbc driver installed on the target machine? pyodbc requires the odbc driver to be present on the OS.

[fernando_albuqu]

I'm sorry, it's my fault. Pyodbc was a test, and I ended up copying the wrong message. The message I'm receiving is "Error(No module named 'pymssql') "

[Mike_L · Accepted solution]

Make sure that you run build plugin with Python 3.8 64 bit (if you are on OA/AG 1.231+, otherwise 3.6) on the same OS architecture as the AG.

[fernando_albuqu]

Thanks Mike.

It was precisely the fact that I was using python version 3.9 that caused me this problem.

Regards,

Fernando.