⇤ ← Revision 1 as of 2006-08-26 02:54:57
27
Comment:
|
1131
|
Deletions are marked like this. | Additions are marked like this. |
Line 1: | Line 1: |
Describe SQL Server here. | #pragma section-numbers off [[TableOfContents]] == Masthead == URL:: http://www.microsoft.com/sql/default.mspx licence:: Commercial software, although a free edition "SQL Server 2005 Express" is available. platforms:: Windows 2000 and later. == DB API 2.0 Drivers == === adodbapi === URL:: http://adodbapi.sourceforge.net/ SourceForge:: http://sourceforge.net/projects/adodbapi licence:: LGPL platforms:: Windows only === pymssql === URL:: http://pymssql.sourceforge.net/ SourceForge:: http://sourceforge.net/projects/pymssql licence:: LGPL platforms:: Windows and Unix ==== Comments ==== == Other Drivers == === ODBC === It is possible to connect to an SQL Server database using ODBC, either the mxODBC driver or the one included with Win32all. However, this is not recommended - adodbapi is a better solution, in part because it supports unicode. == Pros == SQL Server is a robust and fully-featured database, and it performs very well. Moreover, I have not had any problems using this database with Python. == Cons == * Windows only * Not free |
Masthead
- URL
- licence
- Commercial software, although a free edition "SQL Server 2005 Express" is available.
- platforms
- Windows 2000 and later.
DB API 2.0 Drivers
adodbapi
- URL
- SourceForge
- licence
- LGPL
- platforms
- Windows only
pymssql
- URL
- SourceForge
- licence
- LGPL
- platforms
- Windows and Unix
Comments
Other Drivers
ODBC
It is possible to connect to an SQL Server database using ODBC, either the mxODBC driver or the one included with Win32all. However, this is not recommended - adodbapi is a better solution, in part because it supports unicode.
Pros
SQL Server is a robust and fully-featured database, and it performs very well. Moreover, I have not had any problems using this database with Python.
Cons
- Windows only
- Not free