How to integrate Enthought Canopy with SQL Server?

I am new to Python and using Enthought Canopy Express for learning purpose. As part of that I am looking for an option to connect Canopy Express with SQL Server. Couldn't find any materials. Please share methods for database connection for data collection?

Upvotes: 2

Views: 313

Answers (1)

Tim D
Tim D

Reputation: 1743

PEP 249 defines a standard interface for database programming in Python. There are a number of Python packages implementing that interface that can help you connect with SQL Server. You might try looking at pyodbc. There are some others listed here

If you just want to get some experience using SQL statements in Python, you might want to start with the sqlite3 package.

Upvotes: 0

Related Questions