SAP DB:ODBC Instalační příručka Strana 113
- Strana / 225
- Tabulka s obsahem
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
6. mxODBC Connection Objects
Cursors also support the context manager API, so the above could be simplified
even more to:
with connection:
with connection.cursor() as cursor:
cursor.execute('INSERT INTO table VALUES (?, ?)', (1, 2))
… other tasks …
6.6 Unicode/ANSI Connections
Starting with mxODBC 3.1, it is possible to tell the ODBC driver manager whether
to use the Unicode ODBC interface of a supporting ODBC driver or the ANSI (8-
bit string) ODBC interface at connection time.
6.6.1 Unicode ODBC Interface
If the ODBC driver supports the ODBC Unicode interface and you select the
Unicode interface by using a Unicode string as connection parameter, the ODBC
manager will subsequently convert all ANSI-parameters to Unicode and then call
the Unicode APIs of the ODBC driver. Unicode parameters are passed through as-
is to the ODBC driver.
For ODBC drivers that natively support the ODBC Unicode interface, connecting
using a Unicode connection string and subsequently using Unicode parameters
for all execution and catalog methods may result in better performance or
improved compatibility.
Example:
# Use the Unicode ODBC API of the driver by using a Unicode connection
# string
db = mx.ODBC.Windows.DriverConnect(u'DSN=mydb;UID=uid;PWD=pwd')
6.6.2 ANSI ODBC Interface
If the ODBC driver does not support the ODBC Unicode interface, or you connect
using an ANSI (8-bit string), the ODBC driver manager will subsequently convert
all Unicode parameters to the connection's ANSI code page before calling the
ANSI API on the ODBC driver. ANSI parameters are passed through as-is to the
ODBC driver.
For ODBC drivers that do not support the ODBC Unicode interface, connecting
using an ANSI connection string and subsequently using ANSI parameters for all
execution and catalog methods may result in better performance or improved
compatibility.
Example:
# Use the ANSI ODBC API of the driver by using an 8-bit connection
91
- 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
Související produkty a manuály pro Software SAP DB:ODBC
Software SAP DB:ODBC Uživatelský manuál
(7 stránky)
(7 stránky)
Software SAP DB:ODBC Průvodce řešením problémů
(124 stránky)
(124 stránky)
Software SAP DB:ODBC Uživatelský manuál
(49 stránky)
(49 stránky)
Software SAP DB:ODBC Specifikace
(196 stránky)
(196 stránky)
Pfister 8T5-CS1C manuali
Manuali dei proprietari e guide per l'utente per Accessori per l'acqua Pfister 8T5-CS1C.
We fornisce 1 manuali pdf Pfister 8T5-CS1C per scaricare gratuitamente in base al tipo di documento: Manuale Utente
Komentáře k této Příručce