What's the best technology for connecting from linux to MS SQL Server using python? ODBC?

By best, I mean most-common, easiest to setup, free. Performance doesn't matter.

Which method is used for connecting SQL with Python?

To create a connection between the MySQL database and Python, the connect() method of mysql. connector module is used. We pass the database details like HostName, username, and the password in the method call, and then the method returns the connection object.

Which package in Python helps in connecting SQL and Python?

sqlite3 , mysql-connector-python , and psycopg2 allow you to connect a Python application to SQLite, MySQL, and PostgreSQL databases, respectively. Now you can: Interact with SQLite, MySQL, or PostgreSQL databases. Use three different Python SQL modules.

I decided that pyodbc was the best fit. Very simple, stable, supported:
http://code.google.com/p/pyodbc/