Sun-microsystems eWay JDBC/ODBC Adapter Manuel d'utilisateur Page 118
- Page / 133
- Table des matières
- DEPANNAGE
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Appendix A Section A.1
JDBC/ODBC Drivers AS/400 Toolbox Driver
JDBC/ODBC eWay Adapter User’s Guide 118 Sun Microsystems, Inc.
What’s In This Chapter:
AS/400 Toolbox Driver on page 118
Attunity Driver on page 119
MySQL Connector/J Driver on page 121
PostgreSQL Driver on page 122
SyBase JConnect Driver on page 124
Sequelink DataDirect Informix ODBC Driver on page 125
Sequelink DataDirect MS Access ODBC Driver on page 126
Tera data D river on page 128
Installing JDBC/ODBC Drivers on page 129
Troubleshooting on page 130
Refer to the supplied Readme.txt file for information regarding the location of the
required driver files necessary to connect using the JDBC/ODBC eWay.
A.1 AS/400 Toolbox Driver
Configuration Properties:
OTD Wizard: Database Connection Information on page 118
Environment Properties on page 119
A.1.1 OTD Wizard: Database Connection Information
To connect to AS/400, use the information provided in Table 24 to complete the
Connect to Database step of the JDBC/ODBC OTD Wizard. To access DB2, it is
recommended to use the DB2 eWay Adapter or the DB2 Connect eWay Adapter.
Table 24 AS/400 Database Connection Information
Parameter Value
Driver Jar Files jt400.jar
Driver Java Class Name com.ibm.as400.access.AS400JDBCDriver
URL Connection String jdbc:as400://<server-name>:<server-port>/
Note: NOTE: Default server port is 446.
User Name Login name of the account used to access the AS/400 database.
Password Password associated with the login account name used to
connect to the AS/400 database.
- USER’S GUIDE 1
- Contents 3
- Using JDBC/ODBC Operations 57 4
- JDBC/ODBC Drivers 117 6
- Index 131 6
- Chapter 1 7
- JDBC Drivers 7
- Type I: JDBC-ODBC Bridge 8
- Type One Driver 8
- Type II: Partial Java driver 9
- Type Two Driver 9
- Type Three Driver 10
- Chapter 1 Section 1.1 11
- About the JDBC/ODBC eWay 13
- What’s New in This Release 13
- About This Document 14
- Related Documents 15
- Documentation Feedback 16
- Installing the JDBC/ODBC eWay 17
- Platform Suite Installation 18
- After Installation 19
- Chapter 2 Section 2.2 20
- Chapter 2 Section 2.3 21
- Viewing Alert Codes 22
- Note: Confirm with the 23
- Administration Guide 24
- Chapter 3 25
- Outbound JDBC eWay 26
- Outbound JDBC XA eWay 26
- Chapter 3 Section 3.2 27
- Inbound JDBC eWay 29
- Chapter 3 Section 3.4 30
- Properties 31
- Inbound JDBC eWay Properties 32
- Outbound JDBC eWay Properties 32
- JDBC Connector Settings 33
- Connection Retry Settings 34
- Chapter 3 Section 3.5 36
- About the Database OTD Wizard 41
- Creating a New JDBC OTD 41
- Select Wizard Type 42
- Connect To Database 42
- Select Database Objects 43
- Select Tables/Views/Aliases 44
- Chapter 4 Section 4.2 45
- Select Procedures 48
- Figure 21 Edit Resultset 51
- Add Prepared Statement 52
- Specify the OTD Name 55
- Review Selections 55
- Chapter 4 Section 4.3 56
- Using JDBC/ODBC Operations 57
- Chapter 5 Section 5.1 58
- Chapter 5 Section 5.2 59
- The Table 60
- The Insert Operation 61
- The Update Operation 62
- The Stored Procedure 63
- Executing Stored Procedures 64
- Procedure 65
- Prepared Statement 67
- Batch Operations 67
- Statements 68
- Sample Projects 69
- Chapter 6 Section 6.1 70
- Sample Project Data 71
- Running the Sample Projects 72
- Running the SQL Script 73
- Importing a Sample Project 73
- Chapter 6 Section 6.5 74
- Creating a Project 75
- Creating the OTDs 75
- Creating a Connectivity Map 76
- Running the Sample 94
- Creating the Business Process 97
- Chapter 6 Section 6.6 100
- Creating the Connectivity Map 107
- Binding the eWay Components 108
- Creating an Environment 109
- Configuring the eWays 110
- Running the Sample Project 115
- JDBC/ODBC Drivers 117
- AS/400 Toolbox Driver 118
- Attunity Driver 119
- Environment Properties 120
- MySQL Connector/J Driver 121
- PostgreSQL Driver 122
- SyBase JConnect Driver 124
- Appendix A Section A.6 125
- Teradata Driver 128
- Installing JDBC/ODBC Drivers 129
- Troubleshooting 130
Produits connexes et manuels pour Matériel Sun-microsystems eWay JDBC/ODBC Adapter
(182 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.038 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels