Closed myamullaciencia closed 2 years ago
Duplicate of #981
Are these unofficial wheels as a workaround (https://www.lfd.uci.edu/~gohlke/pythonlibs/#pyodbc)) safer ? any other work around ? and when can we expect this to be support python 3.10?
if my python downgrades to 3.7 would this be worked out ?
if my python downgrades to 3.7 would this be worked out ?
Yes, there are Windows wheels for Python 3.7 on PyPI.
I hope this may help you https://stackoverflow.com/questions/71295840/python-pip-error-legacy-install-failure
I downgraded python to 3.7. I ran the command python application.py and still error ModuleNotFoundError: No module named 'pyodbc'. How can I fix it?
This is my error
<<
(venv) testadmin@linux-vm-west2:~/testadmin$ python application.py
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/testadmin/venv/lib/python3.8/site-packages/flask/app.py", line 2095, in call
return self.wsgi_app(environ, start_response)
File "/home/testadmin/venv/lib/python3.8/site-packages/flask/app.py", line 2080, in wsgi_app
response = self.handle_exception(e)
File "/home/testadmin/venv/lib/python3.8/site-packages/flask/app.py", line 2077, in wsgi_app
response = self.full_dispatch_request()
File "/home/testadmin/venv/lib/python3.8/site-packages/flask/app.py", line 1525, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/testadmin/venv/lib/python3.8/site-packages/flask/app.py", line 1523, in full_dispatch_request
rv = self.dispatch_request()
File "/home/testadmin/venv/lib/python3.8/site-packages/flask/app.py", line 1509, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(req.view_args)
File "/home/testadmin/FlaskExercise/views.py", line 12, in home
animals = models.Animal.query.all()
File "/home/testadmin/venv/lib/python3.8/site-packages/flask_sqlalchemy/init.py", line 552, in get
return type.query_class(mapper, session=self.sa.session())
File "/home/testadmin/venv/lib/python3.8/site-packages/sqlalchemy/orm/scoping.py", line 47, in call
sess = self.registry()
File "/home/testadmin/venv/lib/python3.8/site-packages/sqlalchemy/util/collections.py", line 1010, in call
return self.registry.setdefault(key, self.createfunc())
File "/home/testadmin/venv/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 4205, in call
return self.class(local_kw)
File "/home/testadmin/venv/lib/python3.8/site-packages/flask_sqlalchemy/init.py", line 176, in init
bind = options.pop('bind', None) or db.engine
File "/home/testadmin/venv/lib/python3.8/site-packages/flask_sqlalchemy/init.py", line 998, in engine
return self.get_engine()
File "/home/testadmin/venv/lib/python3.8/site-packages/flask_sqlalchemy/init.py", line 1017, in get_engine
return connector.get_engine()
File "/home/testadmin/venv/lib/python3.8/site-packages/flask_sqlalchemy/init.py", line 594, in get_engine
self._engine = rv = self._sa.create_engine(sa_url, options)
File "/home/testadmin/venv/lib/python3.8/site-packages/flask_sqlalchemy/init.py", line 1027, in create_engine
return sqlalchemy.create_engine(sa_url, *engine_opts)
File "
Are you sure you're using Python 3.7 ? Those paths say 3.8.
Are you sure you're using Python 3.7 ? Those paths say 3.8.
oh sorry, I just downgraded to 3.7 and still got the same error
Checked Everything including python path, version , dependencies etc. Nothing works.
Here https://docs.microsoft.com/en-us/azure/databricks/kb/libraries/install-pyodbc-on-cluster In Set up solution in a single notebook
I have these environment and i would like to install pyodbc to work with accdb and mdb files.
I have created a virtual environment venv where i 'm trying to install the pyodbc as
python -m pip install pyodbc
Here it gives an error as:
I have verified that MS Visual C++ is already installed and but it is still giving an error.
could you please help me out to solve this on priority ?