HiT Software, Inc., A BackOffice Associate, LLC CompanyBackOffice Associates
Buy Download Contact Us


Chinese Website 
Japanese Website 




Overview

htmlStd. Edition

htmlDev. Edition
Database Connectivity Overview

pdfPDF
Case Studies

case studiesView

Download


HiT OLEDB Server/400 Std. EditionStd. Edition

HiT OLEDB Server/400 Dev. EditionDev. Edition


Purchase

USA and Canada
sales@hitsw.com
+1-408-345-4001
 
Asia
Australia
Europe
Latin America

as/400 iseries, ibm i ole db driver for sql server : database connectivity


 
ODBC driver for IBM i, iSeries and AS/400  


Database Connectivity for IBM i

HiT OLEDB Server/400 Standard Edition evaluation
Standard Edition

HiT OLEDB Server/400
HiT OLEDB Server/400 Developer Edition

SQL MIDDLEWARE FOR WINDOWS SERVERS
 
HiT OLEDB Server/400 is Windows middleware for IBM DB2 for i SQL access from custom server applications and third party products. HiT OLEDB Server/400 accepts application SQL commands via ADO or directly via its object properties and methods. It then translates these into native DB2 SQL for high-performance, communicates with the IBM i to access, retrieve, and update DB2 data. All communication with the IBM i can also be optionally encrypted and authenticated via SSL v3.0 support. Leveraging the IBM Optimized Database Server protocol standard, HiT OLEDB Server/400 uses native IBM server programs and does not require any additional software on the IBM i platform. HiT OLEDB Server/400 supports Windows 32 and 64-bit server platforms including Windows Server 2008/2003/2000 and Windows NT 4.0.

HiT OLEDB Server/400 supports full SQL functionality for maximum application performance including stored procedures, multiple result sets, and static SQL/packages. Multi-threading and re-entrancy support ensure high performance for client applications. Its unique dbXpress performance feature also significantly speeds applications.
 

OLE DB AS/400 client/server access with HiT OLEDB/400
 

Leveraging the IBM i's Optimized Database Server subsystem, HiT OLEDB Server/400 can communicate over TCP/IP or APPC connections and supports all operating system versions after V3R7. To ensure high application performance, HiT OLEDB Server/400 supports the most flexible NT Server multi-threading models.

OLEDB provider support includes data source, session, transaction, command, rowset, and error COM objects. A complete set of data type mapping between DB2 and OLE DB/ADO environments is supported and documented.

HiT OLEDB Server/400 database schema support is based on the ANSI SQL92 specification. Schema information retrieved using predefined schema rowsets via I DBSchemaRowset::GetRowset interfaces. Applications can specify simple restrictions, such as returning all the columns in a particular table.

Security is supported via the IDBProperties interface, where applications can request the type of authentication/authorization mechanism they want to use.

Support is included for OLE DB and ADO connection pooling.

The included OLEDB Toolbox allows easy data link definition and diagnostics. Additionally, the HiT OLEDB/Workshop, included in the Developer Edition, provides powerful trace and debugging tools to help troubleshoot and optimize application performance, and convenient SQL package management.

A Developer Edition of the product drastically cuts web application development time by providing developers with a C# Toolkit. Using ADO.NET, C# toolkit samples show you how to query and update IBM DB2 for i tables, control related i OS subsystems, and retrieve DB2 data for redirection to web applications. Included source code demonstrates connections using ADO.NET recordsets, executing stored procedures, retrieving table data, inserting table data, and displaying results. All samples work with any OS/400 or IBM i operating systems V3R7 or higher.

A client OLEDB provider, HiT OLEDB/400, is also available.

 
HiT OLEDB Server/400 Standard Edition
Standard Edition
Full Support
during Trial Period
HiT OLEDB Server/400 Developer Edition
Developer Edition
Full Support
during Trial Period

 
Key Features   Benefits
ADO level 2.x compliance
ADO.NET compliance
  Latest tools accessibility

Stored procedures and multiple result sets
support
 
Static SQL/package support
  Fast data access
 
 
 
Distributed Transaction Support
 
  Complex transactions support over multiple
databases
Multi-threading support   Performance and scalability
dbExpress and Connection Pooling   Performance
SSL v3.x encryption and authentication
support
  Secure data transmission
 
Multiple OS version support   Flexible deployment
Debug/trace tools   Fast diagnostics
Silent install support   Fewer IT support issues during deployment
TCP/IP connectivity support   Common network transport
Double-byte support   International DB2 server access
ODBS Native protocol support
  Server Stability
Distributed program call support CL
Command Execution
  Business logic and utility access
 
Complete set of data types supported
and documented
  Seamless translation between EBCDIC and
ANSI character sets
HiT Server Manager and C# Toolkit
with Developer Edition
  Remote monitoring management and
reduced development time

Supported DB2/400 Data Types
 
In rowsets and as parameter values, HiT OLEDB Server/400 maps IBM DB2 for i data types to OLE DB-defined data types. The following data types are supported:
 
DATE   FIXED GRAPH
TIME   VARGRAPH
TIMESTAMP   LONG VARGRAPH
CHAR   VARCHAR
LONG VARCHAR   CHAR FOR BIT DATA
VARCHAR FOR BIT DATA   LONG VARCHAR FOR BIT DATA
DECIMAL   NUMBERIC
INTEGER   SMALLINT
REAL   FLOAT

Supported OLEDB Data Types
DBTYPE_12   DBTYPE_I4
DBTYPE_R4   DBTYPE_R8
DBTYPE_CY   DBTYPE_DATE
DBTYPE_BSTR   DBTYPE_IDISPATCH
DBTYPE_ERROR   DBTYPE_BOOL
DBTYPE_VARIANT   DBTYPE_IUNKNOWN
DBTYPE_DECIMAL   DBTYPE_UI1
DBTYPE_ARRAY   DBTYPE_BYREF
DBTYPE_I1   DBTYPE_UI2
DBTYPE_UI4   DBTYPE_I8
DBTYPE_UI8   DBTYPE_GUID
DBTYPE_VECTOR   DBTYPE_FILETIME
DBTYPE_BYTES   DBTYPE_STR
DBTYPE_WSTR   DBTYPE_NUMERIC
DBTYPE_DBDATE   DBTYPE_DBTIME
DBTYPE_DBTIMESTAMP   DBTYPE_VARNUMERIC

Data Source Object Interfaces
IDBCreateSession
IDBInitialize
IDBProperties
IPersistFile
IPersist
ISupportErrorInfo
IDBInfo
IDBDataSourceAdmin
 
Session Object Interfaces
IGetDataSource
IOpenRowset
ISessionProperties
IObjectWithSite
IDBCreateCommand
IDBSchemaRowset
ISupportErrorInfo
IIndexDefinition
ITransactionLocal
 
Transaction Object Interfaces
Itransaction
ItransactionLocal
 
Command Object Interfaces
ICommand
IObjectWithSite
IAccessor
ICommandProperties
ICommandText
IColumnsInfo
IConvertType
ICommandPrepare
ICommandWithParameters
ISupportErrorInfo
IColumnsRowset
 
Rowset Object Interfaces
IAccessor
IRowsetInfo
IColumnsInfo
IConvertType
IMultipleResults
IObjectWithSite
IRowsetIdentity
IRowset
IRowsetChange
IRowsetLocate
ISequentialStream
ISupportErrorInfo
IColumnsRowset
 
Error Lookup Object Interfaces
IErrorLookup
 
Schema Rowset Support
 
The following schema tables are supported by HiT OLEDB Server/400 (for each schema table the supported columns are listed):
 
Schema Rowset GUID
DBSCHEMA_TABLES
DBSCHEMA_COLUMNS
DBSCHEMA_PROVIDER_TYPES
DBSCHEMA_CATALOGS
DBSCHEMA_INDEXES
DBSCHEMA_SCHEMATA
DBSCHEMA_PROCEDURES
DBSCHEMA_PROCEDURES_PARAMETERS

System Requirements:
 
For the Windows Server
Windows Server 2008 (32/64-bit), Windows Server 2003 (32/64 bit), Windows Server 2000 or
    Windows NT Server 4.0
Network card operable with network protcols
Support for TCP/IP or APPC network protocols
 
For the DB2 Server
OS/400 or IBM i operating system V3R7 or higher
 

 
HiT OLEDB Server/400 Standard Edition
Standard Edition
Full Support
during Trial Period
HiT OLEDB Server/400 Developer Edition
Developer Edition
Full Support
during Trial Period

 

2012 HiT Software, Inc., A BackOffice Associates, LLC Company. All Rights Reserved.