SAP DB:ODBC Przewodnik Instalacji Strona 40
- Strona / 225
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
mxODBC - Python ODBC Database Interface
3. Access Databases using mxODBC
mxODBC provides an easy to use way of accessing the ODBC API of ODBC
managers and drivers from Python. Together with a suitable ODBC driver installed
on the machine where you are running the Python application, you can connect to
your databases with a single Python call.
3.1 ODBC Application Stack
The typical ODBC application setup looks like this:
Python Application
↓
mxODBC
↓
ODBC Manager (Windows, unixODBC, iODBC, DataDirect)
↓
ODBC Driver
↓
(Network, Local Connection, Pipe, Shared Memory)
↓
Database
The upper blue part in the diagram executes within the process of the Python
application. The green part usually runs in a separate process and possibly also on
a different machine.
3.1.1 Architecture: 32-bit vs. 64-bit
As a result of this process setup outlined in the previous section, it is important
that you choose the right ODBC driver type for your application:
18
- 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
Powiązane produkty i podręczniki dla Oprogramowanie SAP DB:ODBC
Oprogramowanie SAP DB:ODBC Instrukcja Naprawy
(124 strony)
(124 strony)
Oprogramowanie SAP DB:ODBC Dokumentacja
(196 strony)
(196 strony)
© 2020, manymanuals.pl. Wszelkie prawa zastrzeżone. | 0.018 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji