Reputation: 21
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
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