SAP DB:ODBC Guide d'installation Page 25
- Page / 225
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
1. Introduction
o cursor.scroll() to scroll the cursor in result sets without actually
fetching data.
o cursor.prepare() to prepare SQL statements for execution,
without actually running them. This allows creating pools of
cursors for dedicated purposes.
o connection.autocommit to easily turn on/off the ODBC
autocommit feature
o cursor and connection objects usable as context managers
o cursor.executemany() accepts iterators/generators as parameter
"sequence".
o cursor.cursortype to easily adjust the used ODBC cursor type to
your application's needs.
o ODBC cursor/connection option methods to adjust ODBC
cursors/connections to your application's needs and optimize
performance by e.g. declaring a connection read-only.
• Configurable Data Type Mappings:
o Supports Python type binding and Database type binding for
efficient data exchange.
o Supports mxDateTime and Python's time and datetime modules
for date/time value exchange.
o Supports standard Python floats, integers, longs and Python's
decimal module for loss-less numeric value exchange.
o Supports Python 2.7 memoryview objects.
o Automatically handles and supports unknown data types and
user data types via string conversion.
• Full Unicode Support: use Unicode for managing text data in your client
applications - even if the database does not natively support Unicode,
mxODBC will automatically provide the necessary conversions on-the-fly.
mxODBC supports both the Unicode or the ANSI ODBC APIs. You can
chose the optimal approach for your driver.
• Multi-Version Python Support: mxODBC works with Python 2.4, 2.5, 2.6
and 2.7.
1
• Full 64-bit Support: mxODBC runs on the following 64-bit platforms
natively: Windows, Linux, FreeBSD and Mac OS X.
1
Please note that mxODBC 3.3 will be the last release to support Python 2.4, 2.5 and 2.6.
The next release will only support Python 2.7 and Python 3.
3
- 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
Produits connexes et manuels pour Logiciel SAP DB:ODBC
Logiciel SAP DB:ODBC Guide de dépannage
(124 pages)
(124 pages)
Logiciel SAP DB:ODBC Manuel d'utilisateur
(49 pages)
(49 pages)
Logiciel SAP DB:ODBC Spécifications
(196 pages)
(196 pages)
© 2020, manymanuals.fr. Tous droits réservés | 0.098 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels