Cannot install pyodbc

[TeresaTA]

I'm trying to make an sql connection throw python in android studio using sqlalchemy, but sqlalchemy uses pyodbc to make the connection and android studio cannot install the pyodbc package. I've tried with pip and git, neither worked.

building 'pyodbc' extension
error: CCompiler.compile: Chaquopy cannot compile native code

---

Command "C:\Anaconda\python.exe -u -S -c "import setuptools, tokenize;file='C:\Users\ttabreu\AppData\Local\Temp\pip-install-w1m5ng44\pyodbc\setup.py';f=getattr(tokenize, 'open', open)(file);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, file, 'exec'))" bdist_wheel -d C:\Users\ttabreu\AppData\Local\Temp\pip-wheel-ttkbmvay --python-tag py3" failed with error code 1 in C:\Users\ttabreu\AppData\Local\Temp\pip-install-w1m5ng44\pyodbc
error: CCompiler.compile: Chaquopy cannot compile native code

ERROR: Failed to install pyodbc from https://files.pythonhosted.org/packages/81/0d/bb08bb16c97765244791c73e49de9fd4c24bb3ef00313aed82e5640dee5d/pyodbc-4.0.30.tar.gz.
Failed to install pyodbc from https://files.pythonhosted.org/packages/81/0d/bb08bb16c97765244791c73e49de9fd4c24bb3ef00313aed82e5640dee5d/pyodbc-4.0.30.tar.gz.

For assistance, please raise an issue at https://github.com/chaquo/chaquopy/issues.
Chaquopy: Exit status 1

[mhsmith]

Thanks for the report. This package isn't currently a priority, but if anyone else wants it too, please click the thumbs-up button above and subscribe to this issue.

Meanwhile, instead of accessing the database server directly from an app, you could run a web server on the same server, and access the database through that.

[mhsmith]

It's been nearly a year and only one person has requested this package, so we won't be adding it in the foreseeable future. If anyone else is interested, please post a comment and I'll reopen the issue.

[lsbenet]

需要这个包

[mhsmith]

The package build tool is now open-source, so if you'd like to try building this package yourself, follow the instructions here. And if you're successful, please make a pull request so we can add it to the public repository.