SAP DB:ODBC Dokumentacja Strona 61
- Strona / 196
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
5.5.2 To create a generic ODBC3 connection
The following procedure shows how to configure a generic ODBC connection to a database with the
following assumptions:
• The driver is ODBC3
• The driver supports the unixODBC driver manager
1.
Navigate to the directory that contains the odbc.sbo and odbc.prm files.
The configuration files are located in the connectionserver-install-dir/connectionServ
er/odbc directory.
2.
Use an XML editor to open the odbc.sbo file for editing.
3.
Locate the following section:
<DataBases>
<DataBase Active="Yes" Name="Generic ODBC3 datasource">
<Libraries>
...
<Library Platform="Unix">dbd_wddodbc3</Library>
<Library Platform="Unix">dbd_ddodbc3</Library>
<!--Library Platform="Unix">dbd_wuxodbc3</Library-->
<!--Library Platform="Unix">dbd_uxodbc3</Library-->
<!--Library Platform="Unix64">dbd_wux32odbc3</Library-->
<!--Library Platform="Unix64">dbd_ux32odbc3</Library-->
</Libraries>
<Parameter Name="Charset Table" Platform="Unix">datadirect</Parameter>
...
</DataBases>
4.
Comment the first two rows for DataDirect and uncomment one of the next four rows. Make sure
you put the row you uncomment on top of the section, so that it can be read first. Comment out the
<Parameter name="CharSet Table" Platform="Unix"> element.
Note:
• dbd_wddodbc3 specifies the DataDirect-based ODBC3 Unicode driver
• dbd_ddodbc3 specifies the DataDirect-based ODBC3 non-Unicode driver
• dbd_wuxodbc3 specifies the unixODBC-based ODBC3 Unicode driver
• dbd_uxodbc3 specifies the unixODBC-based ODBC3 non-Unicode driver
• dbd_wux32odbc3 specifies the unixODBC-based ODBC3 Unicode driver with 32-bit API rather
than 64-bit (available only on 64-bit platforms)
• dbd_ux32odbc3 specifies the unixODBC-based ODBC3 non-Unicode driver with 32-bit API
rather than 64-bit (available only on 64-bit platforms)
5.
Save and close the odbc.sbo file.
6.
Use an XML editor to open the odbc.prm file for editing.
7.
Add or update any information specific to the database.
Note:
The odbc.prm file may not contain information about specific functions of the database.
8.
Save and close the odbc.prm file.
2012-03-1561
Creating a connection
- Data Access Guide 1
- 2012-03-154 4
- 2012-03-155 5
- 2012-03-156 6
- 2012-03-157 7
- 2012-03-158 8
- 2012-03-159 9
- 2012-03-1510 10
- Contents 10
- Document History 11
- DateVersion 12
- 2.2 Audience of the guide 13
- 2.3 What's new? 13
- 2.4 Key tasks 14
- 2.5 Conventions of the guide 15
- 2012-03-1516 16
- Introduction to data access 17
- 3.2.1 System architecture 18
- 3.2.2 Data access drivers 18
- 2012-03-1519 19
- 2012-03-1520 20
- 3.4 Deployment mode 21
- 3.5 Connectivity services 22
- 2012-03-1523 23
- 2012-03-1524 24
- 4.1.1 64-bit UNIX support 25
- 2012-03-1526 26
- 4.2 Single sign-on support 27
- 4.3 Stored procedures 28
- 2012-03-1529 29
- 2012-03-1530 30
- 4.4 Connection pools 31
- 4.5 Load balancing 32
- 4.5.1 Finding the best server 33
- 4.5.2 Load balancing logic 34
- 4.5.3 Backward compatibility 34
- 4.6 Memory allocation 34
- 4.6.1 To enable HOARD 35
- 4.6.2 To disable HOARD 35
- 2012-03-1536 36
- Creating a connection 37
- 2012-03-1538 38
- 5.2.2 To run the cscheck tool 39
- 5.2.4 Check tool—list 40
- 2012-03-1541 41
- 5.2.6 Check tool—find 42
- 2012-03-1543 43
- 5.2.7 Check tool—middleware 44
- 5.2.8 Check tool—accessdriver 45
- 5.2.9 Check tool—connectivity 46
- 5.2.10 Check tool—ping 47
- 2012-03-1548 48
- 5.3 Creating JDBC connections 49
- 2012-03-1550 50
- 2012-03-1551 51
- 2012-03-1552 52
- 2012-03-1553 53
- 2012-03-1554 54
- 2012-03-1555 55
- 2012-03-1556 56
- 2012-03-1557 57
- 5.5 Creating ODBC connections 58
- 2012-03-1559 59
- 2012-03-1560 60
- 2012-03-1561 61
- 2012-03-1562 62
- Data access driver reference 63
- 6.1.2 File location 64
- 6.1.3 Table mapping 65
- 6.1.4 Schema detection 66
- 2012-03-1567 67
- 6.2 SAP ERP connections 68
- 6.2.1 Driver capabilities 68
- 2012-03-1569 69
- 2012-03-1570 70
- 2012-03-1571 71
- 2012-03-1572 72
- 6.2.4 ERP limitations 73
- 2012-03-1574 74
- Connection reference 75
- 7.2 IBM DB2 connections 76
- 7.4 Oracle EBS connections 77
- 7.6 Oracle RAC connections 78
- 7.8 SAP HANA connections 79
- 7.8.1 Creating a connection 79
- 2012-03-1580 80
- DescriptionOption 81
- 2012-03-1582 82
- 7.9 SAP MaxDB connections 83
- Data Federation 84
- Administration Tool Guide 84
- 7.11 SAS connections 85
- 2012-03-1586 86
- 2012-03-1587 87
- 2012-03-1588 88
- 2012-03-1589 89
- 2012-03-1590 90
- Intelligence Rich Client 91
- 2012-03-1592 92
- Caution: 93
- 2012-03-1594 94
- 9.1 About global parameters 95
- 2012-03-1596 96
- 9.4.1 Charset List Extension 97
- 9.4.2 Config File Extension 97
- 9.4.3 Description Extension 97
- 9.4.5 Load Drivers On Startup 98
- 9.4.6 Max Pool Time 99
- 9.4.7 Setup File Extension 100
- 9.4.8 SQL External Extension 100
- 9.4.9 SQL Parameter Extension 100
- 9.4.10 Strategies Extension 101
- 9.4.12 Validate XML Streams 102
- 2012-03-15103 103
- 9.9 Activating traces 104
- 2012-03-15105 105
- 9.9.3 Reading traces 106
- 2012-03-15107 107
- 2012-03-15108 108
- 2012-03-15109 109
- 10.1.2 Installed SBO files 110
- Sub-directory 111
- SBO fileDatabase technology 112
- Teradata 112
- 10.1.4 To customize SBO files 115
- 2012-03-15116 116
- 10.1.6 JDBC driver properties 117
- 2012-03-15118 118
- 2012-03-15119 119
- 2012-03-15120 120
- SBO parameter reference 121
- 2012-03-15122 122
- 11.3 Common SBO parameters 123
- 11.3.1 Array Bind Available 123
- 11.3.2 Array Bind Size 124
- 11.3.3 Array Fetch Available 124
- 11.3.4 Array Fetch Size 125
- 11.3.6 Catalog Separator 126
- 11.3.7 CharSet Table 127
- 11.3.8 Description File 127
- 11.3.9 Driver Capabilities 128
- 11.3.10 Driver Name 128
- 11.3.11 Escape Character 129
- 11.3.12 Extensions 129
- 11.3.13 Family 130
- 11.3.14 Force Execute 130
- 11.3.16 Include Synonyms 131
- 11.3.17 Introscope Available 131
- 11.3.18 Max Rows Available 132
- 11.3.20 Optimize Execute 133
- 11.3.21 Owners Available 133
- 11.3.22 Qualifiers Available 134
- 11.3.24 Quote Identifiers 135
- 11.3.25 SQL External File 135
- 11.3.26 SQL Parameter File 136
- 11.3.27 SSO Available 136
- 11.3.28 Strategies File 136
- 2012-03-15137 137
- 11.3.30 Type 138
- 11.3.31 Unicode 138
- 11.3.32 URL Format 139
- 11.3.33 XML Max Size 139
- 11.4 JavaBean SBO parameters 140
- 11.4.1 JavaBean Class 140
- 11.5 JCO SBO parameters 140
- 11.5.1 ERP Max Rows 140
- 11.6 JDBC SBO parameters 141
- 11.6.1 Connection Shareable 141
- 11.6.3 ForeignKeys Available 142
- 11.6.4 Get Extended Column 143
- 11.6.5 JDBC Class 143
- 11.6.6 PrimaryKey Available 144
- 11.6.7 PVL Available 144
- 11.6.8 Shared Connection 144
- 11.7 ODBC SBO parameters 145
- 11.7.1 CharSet 145
- 2012-03-15146 146
- 11.7.4 Empty String 147
- 11.7.5 ODBC Cursors 147
- 2012-03-15148 148
- 11.7.9 V5toV6DriverName 149
- 11.8 OLE DB SBO parameters 149
- 11.8.1 Enumerator CLSID 150
- 11.8.2 Provider CLSID 150
- 11.9.1 MSOlap CLSID 150
- 11.10 Open SBO parameters 151
- 11.10.1 Bucket Split Size 151
- 11.11 Sybase SBO parameters 152
- 11.11.1 Driver Behavior 152
- 11.11.2 Password Encryption 152
- 11.11.3 Quoted Identifier 153
- 11.11.4 Recover Errors 153
- 11.11.5 Text Size 154
- 12.2 About PRM files 155
- 2012-03-15156 156
- 2012-03-15157 157
- 2012-03-15158 158
- PRM parameter reference 159
- 13.1.2 ANALYTIC_FUNCTIONS 160
- 13.1.4 DISTINCT 161
- 13.1.5 EXT_JOIN 161
- 13.1.6 FULL_EXT_JOIN 162
- 13.1.7 GROUP_BY 162
- 2012-03-15163 163
- 13.1.11 HAVING 164
- 13.1.12 INNER_JOIN 165
- 13.1.13 INTERSECT 165
- 13.1.14 INTERSECT_ALL 166
- 13.1.15 INTERSECT_IN_SUBQUERY 166
- 13.1.16 JOIN 166
- 13.1.17 LEFT_EXT_JOIN 167
- 13.1.18 LEFT_OUTER 167
- 13.1.20 MINUS 168
- 13.1.21 MINUS_ALL 169
- 13.1.22 MINUS_IN_SUBQUERY 169
- 13.1.23 ORDER_BY 170
- 13.1.27 RANK_SUPPORTED 171
- 13.1.28 RIGHT_EXT_JOIN 172
- 13.1.29 RIGHT_OUTER 172
- 13.1.31 SELECT_SUPPORTS_NULL 173
- 13.1.32 SUBQUERY_IN_FROM 174
- 13.1.33 SUBQUERY_IN_IN 174
- 13.1.34 SUBQUERY_IN_WHERE 174
- 13.1.35 UNION 175
- 13.1.36 UNION_ALL 175
- 13.1.37 UNION_IN_SUBQUERY 176
- 14.1 Data type conversion 177
- 14.1.1 ABAP 178
- 14.1.2 CSV files 178
- 14.1.3 JDBC 179
- 2012-03-15180 180
- Data foundation data type 181
- 14.1.4 ODBC 182
- 14.1.5 OLE DB 185
- 2012-03-15186 186
- 14.1.6 Oracle OCI 187
- 14.1.7 Sybase CTL 188
- 2012-03-15189 189
- 14.3 Multisource universes 190
- More Information 191
- LocationInformation Resource 192
- 2012-03-15193 193
- (continued) 194
- 2012-03-15196 196
Gw-instek PSB-2000 Series SEQUENCE OPERATION GUIDE (Front Pa manuals
Owner’s manuals and user’s guides for Equipment Gw-instek PSB-2000 Series SEQUENCE OPERATION GUIDE (Front Pa.
We providing 1 pdf manuals Gw-instek PSB-2000 Series SEQUENCE OPERATION GUIDE (Front Pa for download free by document types: User Manual
Gw instek PSB-2000 Series SEQUENCE OPERATION GUIDE (Front Pa User Manual (4 pages)
Brand: Gw-instek | Category: Equipment | Size: 0.17 MB |
Table of contents
More products and manuals for Equipment Gw-instek
| Models | Document Type |
|---|---|
| PSB-2000 Series User Manual |
User Manual
GW Instek PSB-2000 Series User Manual User Manual,
160 pages
|
| AFG-2225 User Manual |
User Manual
GW Instek AFG-2225 User Manual User Manual,
301 pages
|
| PSU-Series User Manual |
User Manual
GW Instek PSU-Series User Manual User Manual,
196 pages
|
| PST series Programming Manual |
User Manual
GW Instek PST series Programming Manual User Manual,
24 pages
|
| PSH-A Series 360W User Manual |
User Manual
GW Instek PSH-A Series 360W User Manual User Manual,
39 pages
|
| PSU-Series Programming User Manual |
User Manual
GW Instek PSU-Series Programming User Manual User Manual,
128 pages
|
| AFG-3000 Series |
User Manual
GW Instek AFG-3000 Series User Manual [fr] ,
304 pages
|
| PSW-Series Programming & Command manual |
User Manual
GW Instek PSW-Series Programming & Command manual User Manual,
118 pages
|
| GPS-x303 Series |
User Manual
GW Instek GPS-x303 Series User Manual,
16 pages
|
| PSW-Series User Manual |
User Manual
GW Instek PSW-Series User Manual User Manual,
184 pages
|
| PEL-3000 Series Quick Start Guide |
User Manual
GW Instek PEL-3000 Series Quick Start Guide User Manual,
21 pages
|
| PEL-2000 Series Programming User Manual |
User Manual
GW Instek PEL-2000 Series Programming User Manual User Manual,
170 pages
|
| PEL-3000 Series Programming Manual |
User Manual
GW Instek PEL-3000 Series Programming Manual User Manual,
174 pages
|
| APS-1102 LabVIEW Driver User Manual |
User Manual
GW Instek APS-1102 LabVIEW Driver User Manual User Manual,
38 pages
|
| PEL-3000 Series User Manual |
User Manual
GW Instek PEL-3000 Series User Manual User Manual,
215 pages
|
| APS-1102 Control Software User Manual |
User Manual
GW Instek APS-1102 Control Software User Manual User Manual,
134 pages
|
| APS-1102 User Manual |
User Manual
GW Instek APS-1102 User Manual User Manual,
265 pages
|
| PEL-2000 Series User Manual |
User Manual
GW Instek PEL-2000 Series User Manual User Manual,
268 pages
|
| APS-1102 Control Software User Manual |
User Manual
GW Instek APS-1102 Control Software User Manual User Manual,
96 pages
|
| PSM-Series Programming Manual |
User Manual
GW Instek PSM-Series Programming Manual User Manual,
36 pages
|
© 2020, manymanuals.pl. Wszelkie prawa zastrzeżone. | 0.031 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji