CODEWITHSUNDEEP
pythonsql-serverubuntu
geer
geer

Reputation: 305

How to connect to remote MS SQL Server from python using py(py)odbc

I have a remote ms sql server at office location and I wanted to connect from an ubuntu desktop to it. I installed DBeaver http://dbeaver.jkiss.org/ and it was working like a charm without any other dependency.

After this I started to setup a connection from python with no success until I found a straightforward tutorial at https://tryolabs.com/blog/2012/06/25/connecting-sql-server-database-python-under-ubuntu/. But this solution involved installing some packages to ubuntu itself and configuring some related config files in the system.

The question is if there is some python package to use without os dependencies?

Upvotes: 1

Views: 1409

Answers (1)

restless1991
restless1991

Reputation: 51

I don't think you would be able to achieve what you want without installing some packages. Reason being you are connecting to the MSSQL which follows a different set of rules as it is from Microsoft.

If you were connecting to any DB (MySQL,MongoDB etc) you still need to install a package or module to make it work.

Try to install the package as described in the tutorial from the like you shared and if you run into any problem paste the problem here.

Upvotes: 1

Related Questions