SAP DB:ODBC Przewodnik Instalacji Strona 86
- Strona / 225
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
mxODBC - Python ODBC Database Interface
•
db.setinputsizes() and db.setoutputsizes() are dummy
functions; this is allowed by DB API 2.0.
• The type objects / constructors (formerly found in the
dbi module
defined by DB API 1.0) are only needed if you want to write database
independent code.
• The connection constructor is available under three different names:
ODBC() (DB API 1.0), connect() (DB API 2.0) and Connect() (mxODBC
specific). See the next section for details on the used parameters.
mxODBC also defines a
DriverConnect() constructor which is available
for ODBC managers and some ODBC drivers. If you can, please use the
DriverConnect() API since this provides more flexibility in configuring
the connection.
5.1.2 Extensions
mxODBC extends the DB-API specification in a significant number of ways to
provide access to as many ODBC features as possible. If you want to stay
compatible to other Python DB-API compliant interface, you should only use
those interfaces which are mentioned in the Python DB-API specification
documents.
5.2 mxODBC and the ODBC Specification
Since ODBC is a widely supported standard for accessing databases, it should in
general be possible to use the package with any ODBC version 2.0 - 3.8
compliant ODBC database driver/manager. mxODBC prefers ODBC 3.x over 2.x
in case the driver/manager supports both versions of the standard.
5.2.1 Full access to most ODBC features
The ODBC API is very rich in terms of accessing information about what is stored
in the database. mxODBC makes most of these APIs available as additional
connection and cursor methods and these can be put to good use for database
and schema introspection.
Since many of the parameters and names of the ODBC function names were
mapped directly to Python method names (by dropping the SQL prefix and
converting them to lower-case), we kindly refer you to the Microsoft ODBC
Documentation and your ODBC driver documentation for low-level details on the
various APIs.
64
- 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)
Grills Handbücher
Wählen Sie Ihre Marke Grills aus, um Benutzerhandbücher und Anleitungen herunterzuladen
© 2020, manymanuals.pl. Wszelkie prawa zastrzeżone. | 0.051 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji