SAP DB:ODBC Installation Guide download pdf (Page 208)

mxODBC - Python ODBC Database Interface

Note:

When connecting to a database with transaction support, you should explicitly

do a .rollback() or .commit() prior to closing the connection. In the

example this was omitted since the used MySQL database backend does not

support transactions and we were only reading from the database.

186

1 2 ... 203 204 205 206 207 208 209 210 211 212 213 ... 224 225

ODBC Database Interface 1
Contents 3
1.2 Features 24
1.3 Requirements 26
Mac OS X 27
2. Installation 28
Operating System Platform 29
Python Build Version 29
2.2.1 Prerequisites 30
2.2.2 Before You Start 30
License Files 31
Step 1 31
2.2.4 Uninstall 32
2.3.2 Before You Start 33
Step 2 34
Step 3 35
Step 4 35
2.4.1 Before You Start 36
2.3.4 Uninstall 36
2.4.3 Uninstall 38
Manual Uninstall 39
3.1 ODBC Application Stack 40
[Microsoft][ODBC Driver 42
Windows Registry Keys 43
3.2.6 DSN-less Connections 45
[ODBC Data Sources] 49
[ODBC Drivers] 50
ODBCINI 50
ODBCINSTINI 50
3.3.7 DSN-less Connections 52
DNS-less Connection String 53
4.1 MS SQL Server 54
Driver Limitations 58
[MONET] 60
4.1.2 General Notes 61
Access Violations 63
Kerberos on Linux 64
4.2 MS Access Database 65
4.3 Oracle 65
Driver Notes 66
4.4 IBM DB2 68
4.4.2 General Notes 69
Linker Paths 70
4.5 Sybase ASE 71
4.6 PostgreSQL 73
4.7 MySQL 75
.rownumber to the 76
.rownumber 76
4.8 SAP MaxDB / SAPDB 77
4.9 Teradata 78
ORDER BY clause to 80
4.10 Netezza 81
Netezza and Unicode 82
4.11 Other Databases 83
5. mxODBC Overview 85
5.1.2 Extensions 86
5.3 Supported ODBC Versions 87
5.5 Transaction Support 88
5.5.2 Manual Commit 89
5.6 Stored Procedures 90
Methods 91
parametertypes Parameter 93
5.7 Introspection 98
5.8 ODBC Cursor Types 100
5.8.2 Default Cursor Type 101
MS SQL Server 102
Oracle 102
Factory Functions 103
Predefined Row Factories 105
5.10 mxODBC Subpackages 107
6.2 Connection Type Object 109
6.1 Subpackage Support 109
6.6 Unicode/ANSI Connections 113
# string 114
7. mxODBC Cursor Objects 124
7.2 Subpackage Support 125
7.4 Cursor Type Object 125
7.6 Cursor Object Methods 126
7.6.1 Catalog Methods 135
Common Interface 136
Result Set Layouts 136
Search Pattern Parameters 136
Unicode 137
Available Catalog Methods 137
SQLBindCol() 138
SQLGetData() and 138
7. mxODBC Cursor Objects 139
.gettypeinfo(sqltype) 142
7.7 Cursor Object Attributes 156
Per-Statement Binding Mode 164
8.3 SQL Type Input Binding 165
UNICODE_STRINGFORMAT 166
None singleton is 168
8.5 Output Conversions 171
EIGHTBIT_STRINGFORMAT 172
8.7 Auto-Conversions 175
8.9 Additional Comments 177
Handling 180
10.2 SQL Error Mappings 182
10.4 Error Handlers 183
10.4.2 Examples 184
10.5 Warning Classes 185
10.6 Database Warnings 185
11. mxODBC Functions 188
11.2 mx.ODBC Functions 189
Classes 193
Functions 193
Driver Manager 195
14.4 mx.ODBC.iODBC 197
Manager 197
14.5.1 Notes 199
64-bit Platforms 200
14.7 ODBC Driver Subpackages 202
Running mxODBC with mod_wsgi 204
Freezing mxODBC using py2exe 205
16. Examples 207
18. mxODBC Package Structure 210
19.1.1 211
Windows ODBC Manager 211
19.1.2 iODBC Driver Manager 212
20. History & Changes 214
21. Copyright & License 215
Version 1.3.0 216
1. Introduction 216
2. Terms and Definitions 216
3. License Grant 217
4. Authorizations 217
5. Modifications 218
8. NO WARRANTY 218
9. LIMITATION OF LIABILITY 218
10. Termination 219
11. Indemnification 219
12. Third Party Rights 219
13. High Risk Activities 219
14. General 220
15. Agreement 220
1 CPU License (Example) 221
1. License Grant 221
2. Covered Software 221
3. Authorizations 221
4. Proof 222
7.2 Redistribution 224
8. Proof 224
21. Copyright & License 225

Comments to this Manuals

No comments

SAP DB:ODBC Installation Guide Page 208

Comments to this Manuals

Related products and manuals for Software SAP DB:ODBC