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.

11

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.