MS SQL Driver?
Is there a driver that will permit sqlalchemy to communicate with MS SQL Server? pyodbc requires c libraries so it cannot be installed. MySQL and pymysql work fine but I need to connect to MS SQL.
The drivers work with MySQL but I guess no one has seen a need for a pure python driver for MS SQL.
In case anyone else has the need to use Pythonista to talk to MS SQL server, I just found and successfully tested the pure python MS SQL driver python-tds.
@ihf I don't need it but that's a good news
@ihf, I'm hoping you can point out something simple I have wrong with my python-tds install!
I managed to clone the sqlalchemy_pytds dir from https://github.com/m32/sqlalchemy-tds.git but and I gave pyton-tds (1.11.0) installed according to pip list in stash but when I try and run the below code:
import sqlalchemy import sqlalchemy_tds from sqlalchemy import create_engine conn_str = 'mssql+pytds://xxx' engine = create_engine(conn_str)
I get the error:
The 'python-tds' distribution was not found and is required by the application.
Hope you have come across this error in your attempts to get pytds working for mssql on pythonista and can point me in the right direction!
Do you get an error?
If so, check that you actually installed pytds to your site-packages folder.
Thanks for the reply. If I just test the script:
I get the same “ pkg_resources.DistributionNotFound: The 'python-tds' distribution was not found and is required by the application” error.
I do have the pytds folder in my site-packages -3 folder though.
Given the error is from the line:
__version__ = pkg_resources.get_distribution('python-tds').version
In the init.py from pytds, I wonder if I’m missing that package somehow (if so, any ideas how I could get it?)
Oh, I see the prob. That setup.py is sort of wonky, in that it tries to run git to get the version. I'm not exactly sure what pkg_resources is pulling from, if pip is supposed to populate some database, or what, but it doesn't work in stash.
Since this is only failing on getting the version number, you should be able to hard code it.
What happens if you just replace that line in the unit with this?
__version__ = "1.11.0"
Hard coding the version number works a treat 🙏
Hard coding is something that is a treat, do hard coding and then enjoy your successful coding.