Installation guide

mxODBC - Python ODBC Database Interface
3.3.6
Available Data Source Types (DSNs)....................................................29
User Data Sources (User-DSN).......................................................29
System Data Sources (System-DSN)............................................... 29
File Data Sources (File-DSN)........................................................... 30
3.3.7 DSN-less Connections ......................................................................... 30
Pros and Cons of using DSN-less Connections ............................... 30
DNS-less Connection String............................................................31
4. Accessing Popular Databases ............................ 32
4.1 MS SQL Server.................................................................. 32
4.1.1 Available ODBC Drivers ......................................................................32
MS SQL Server Native Client for SQL Server 2005, 2008 and later . 32
Finding the latest version of the SQL Server Native Client for
Windows................................................................................... 32
Use mxODBC direct execution methods for better performance33
Optimizing SQL Server Native Client Access Method ................ 33
Configuring the SQL Server Native Client Network Protocol...... 33
Multiple active result sets (MARS) on a single connection ......... 34
Parameter Binding with SQL Server 2012 and later.................... 34
Stored procedures with output parameters and result sets ........ 34
MS SQL Server ODBC Driver for SQL Server 2000.........................35
Configuring the SQL Server ODBC Driver Client Network
Protocol..................................................................................... 35
MS SQL Server Native Client for Linux............................................ 35
Driver Limitations...................................................................... 36
Example Configuration for Unix................................................. 36
EasySoft ODBC Driver for SQL Server ............................................ 37
OpenLink ODBC Driver for SQL Server.......................................... 37
DataDirect ODBC Driver for SQL Server ........................................ 37
Actual Technologies Mac OS X ODBC Driver for SQL Server.......... 37
FreeTDS Unix ODBC Driver for SQL Server...................................37
Driver Limitations...................................................................... 37
Example Configuration for Unix................................................. 38
4.1.2 General Notes......................................................................................39
ODBC API Extensions and the SQL Server Native Client.................39
Static vs. forward-only Cursors....................................................... 39
Timestamp Resolution ....................................................................39
Multiple Cursors on Connections / MARS....................................... 40
International Character Data........................................................... 40