How can fix pyodbc error?

anyone knows how can fix this error??? (src/pyodbc.h:56:10: fatal error: sql.h: No such file or directory)

thanks franky…I did it before but dosen’t work…i installed pyodbc

What exactly did you do and what didn’t work?

pip install pyodbc

I also did it too.

What did you do too?
Without precise statements I can’t help either.

The installation alone with pip is not enough.
You need additional packages in the packages.txt
Read the documentation and the thread I linked.

this is my repo in github:

i also put packages.txt but dosent work… i read this post before (Unable to install pyodbc on streamlit sharing - #4 by randyzwitch )

Remove unixodbc from your packages.txt and try again, it is nowhere mentioned in the docs.

Your repo has several issues as far as I can tell:

  1. Your requirements.txt is missing xgboost and joblib
  2. You reference 'Driver={ODBC Driver 17 for SQL Server};', but it doesn’t appear that you are installing it

I would take a step back, make sure your dependencies are correct and that you can load the app without all the database connections. Then, go through and add back pieces until you have a working app. Unfortunately, I cannot help you with SQLServer issues (if present), as I haven’t used it in many years.


when i try app in localhost evey thing is ok but in deploy gets error …i will check it agailn … thaks :pray: :pray: :pray:

thanks :pray: :pray: