Pyodbc package is not installing during function app deployment

Question

Pyodbc package is not installing during function app deployment

Jordan 25

I am using a function app with pyodbc which consistently fails for Failed to import src.services.oauth_service: No module named 'pyodbc'.

Some fixes I've attempted in order:

Python Version Downgrade
ODBC Driver Installation
Added pymssql>=2.2.0 as alternative
Loading services independently

I've also tried to deploy via github CICD and remote build and both are failing as well.

Ranashekar Guda 2,820 Reputation points Microsoft External Staff Moderator

2025-06-25T18:11:12.45+00:00
Hello @Jordan,
To resolve the issue with the pyodbc package not installing during your function app deployment, consider the following steps:

Ensure Compatibility: Verify that the pyodbc package is compatible with the Python version you are using. The package should support the Python version specified in your function app settings.

Check Requirements File: Ensure that your requirements.txt file correctly lists pyodbc and does not include any conflicting packages. You might want to handcraft your requirements.txt instead of using pip freeze, as this can help avoid OS-specific dependencies that could cause issues during deployment.

Build Native Dependencies: If you are manually publishing your package, make sure that both SCM_DO_BUILD_DURING_DEPLOYMENT and ENABLE_ORYX_BUILD are set to true. This ensures that native dependencies are built correctly during deployment.

Use Correct Deployment Method: If you are using GitHub CI/CD or remote builds, ensure that the deployment process is correctly configured to restore packages and build the application in an environment that matches your function app's runtime.

Check for Errors: Look for any specific error messages in the deployment logs that could provide more insight into why the pyodbc module is not being found.

Hope this helps. Do let us know if you any further queries.

Jordan 25

I do not use pip freeze to build requirements its all hand built.

Currently my requirements for pyodbc are pyodbc>=4.0.0 which is low enough to allow many different pyodbc versions to be installed.

I have both of the variables enabled.

Every build I see the package pyodbc has been successfully installed. As you can see here it says pyodbc-5.2.0 was installed. Here is one message:


2025-06-25T18:43:55.9392059Z Successfully installed MarkupSafe-3.0.2 PyJWT-2.10.1 adal-1.2.7 aiohttp-3.9.5 aioodbc-0.5.0 aiosignal-1.3.2 asgiref-3.8.1 async-timeout-4.0.3 asyncio-pool-0.6.0 attrs-25.3.0 azure-common-1.1.28 azure-core-1.34.0 azure-core-tracing-opentelemetry-1.0.0b12 azure-functions-1.23.0 azure-identity-1.23.0 azure-keyvault-4.2.0 azure-keyvault-certificates-4.10.0 azure-keyvault-keys-4.11.0 azure-keyvault-secrets-4.10.0 azure-monitor-opentelemetry-1.6.10 azure-monitor-opentelemetry-exporter-1.0.0b38 azure-storage-blob-12.25.1 certifi-2025.6.15 cffi-1.17.1 charset_normalizer-3.4.2 cryptography-41.0.7 deprecated-1.2.18 exceptiongroup-1.3.0 fixedint-0.1.6 frozenlist-1.7.0 idna-3.10 importlib-metadata-8.6.1 iniconfig-2.1.0 isodate-0.7.2 jsonschema-4.24.0 jsonschema-specifications-2025.4.1 mock-5.2.0 msal-1.32.3 msal-extensions-1.3.1 msrest-0.7.1 msrestazure-0.6.4.post1 multidict-6.5.1 numpy-2.2.6 oauthlib-3.3.1 opentelemetry-api-1.31.1 opentelemetry-instrumentation-0.52b1 opentelemetry-instrumentation-asgi-0.52b1 opentelemetry-instrumentation-dbapi-0.52b1 opentelemetry-instrumentation-django-0.52b1 opentelemetry-instrumentation-fastapi-0.52b1 opentelemetry-instrumentation-flask-0.52b1 opentelemetry-instrumentation-psycopg2-0.52b1 opentelemetry-instrumentation-requests-0.52b1 opentelemetry-instrumentation-urllib-0.52b1 opentelemetry-instrumentation-urllib3-0.52b1 opentelemetry-instrumentation-wsgi-0.52b1 opentelemetry-resource-detector-azure-0.1.5 opentelemetry-sdk-1.31.1 opentelemetry-semantic-conventions-0.52b1 opentelemetry-util-http-0.52b1 packaging-25.0 pandas-2.3.0 pluggy-1.6.0 propcache-0.3.2 psutil-7.0.0 pycparser-2.22 pymssql-2.2.8 pyodbc-5.2.0 pytest-7.4.4 python-dateutil-2.9.0.post0 python-dotenv-1.1.1 pytz-2025.2 referencing-0.36.2 requests-2.32.4 requests-oauthlib-2.0.0 requests-toolbelt-1.0.0 rpds-py-0.25.1 six-1.17.0 tomli-2.2.1 typing-extensions-4.14.0 tzdata-2025.2 urllib3-2.5.0 werkzeug-3.1.3 wrapt-1.17.2 yarl-1.20.1 zipp-3.23.0

Jordan 25 Reputation points

2025-06-26T04:59:00.4366667+00:00

~~I eventually could not get pyodbc working so i switched to pymssql.~~ Nevermind, pymssql is also not working.

1 answer

Your answer

Ranashekar Guda 2,820 Reputation points Microsoft External Staff Moderator

2025-06-25T18:11:12.45+00:00

Hello @Jordan,
To resolve the issue with the pyodbc package not installing during your function app deployment, consider the following steps:

Ensure Compatibility: Verify that the pyodbc package is compatible with the Python version you are using. The package should support the Python version specified in your function app settings.

Check Requirements File: Ensure that your requirements.txt file correctly lists pyodbc and does not include any conflicting packages. You might want to handcraft your requirements.txt instead of using pip freeze, as this can help avoid OS-specific dependencies that could cause issues during deployment.

Build Native Dependencies: If you are manually publishing your package, make sure that both SCM_DO_BUILD_DURING_DEPLOYMENT and ENABLE_ORYX_BUILD are set to true. This ensures that native dependencies are built correctly during deployment.

Use Correct Deployment Method: If you are using GitHub CI/CD or remote builds, ensure that the deployment process is correctly configured to restore packages and build the application in an environment that matches your function app's runtime.

Check for Errors: Look for any specific error messages in the deployment logs that could provide more insight into why the pyodbc module is not being found.

Hope this helps. Do let us know if you any further queries.
Jordan 25 Reputation points

2025-06-26T04:59:00.4366667+00:00

~~I eventually could not get pyodbc working so i switched to pymssql.~~ Nevermind, pymssql is also not working.

Answer 1

Jordan 25

Looks like the answer is to not use Github Actions and do a remote deploy. Every time I use github actions there's a package issue, but I don't have the same error when doing a remote deploy from my local machine.

Share via

Pyodbc package is not installing during function app deployment

1 answer

Your answer