E: Unable to locate package pyodbc

Community Cloud
1 
E: Unable to locate package pyodbc

[17:42:26] ❗️ installer returned a non-zero exit code
2

Remove pyodbc from packages.txt.

3

I removed it as you said, but created a requirements.txt, it no longer gives an error, but it keeps returning forever

actually return this:

[00:46:35] ❗️ error restarting streamlit: exit status 7: output: streamlit: ERROR (not running)
streamlit: ERROR (spawn error)

env: ‘/home/appuser/venv/bin/streamlit’: No such file or directory

env: ‘/home/appuser/venv/bin/streamlit’: No such file or directory
4

You may need to reboot or redeploy the application.

5

Thanks man, now it was deployed, but there was an error that i think is a connection error:

File "/mount/src/estudo/services/database.py", line 7, in <module>

    cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';Trusted_Connection=yes;')

pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

2023-11-30 18:55:41.708 503 GET /script-health-check (10.12.212.227) 15175.55ms

Maybe its because my db is not on ?

6

Indeed the application seems unable to connect to the database. Why that is happenng or whether your db is on or not, I couldn’t tell.

7

I turned on the bd and it continues to give an error, on my machine it works when I run it but it won’t be able to deploy.

Help bro :frowning:, its my first time with streamlit

8

I have no idea. Are you sure your db is reachable from the Internet?

9

Im using SQL Server with windows athentication, can working with internet ?

10

Of course it can, as long as the database, the operating system and the local nerwork are properly configured.