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/400 Std. EditionStd. Edition

HiT OLEDB/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


 
oledb provider : database connectivity  


Database Connectivity for IBM i

HiT OLEDB/400 Standard Edition evaluation
Standard Edition

HiT OLEDB/400

SQL MIDDLEWARE FOR WINDOWS CLIENT PLATFORMS
 
HiT OLEDB/400 (OLE DB for IBM i, iSeries or AS/400) is Windows client middleware for SQL access to IBM DB2 for i servers from custom applications and third party products. HiT OLEDB/400 accepts application SQL commands via ADO or directly via its object properties and methods. It then translates these SQL commands into native DB2 SQL for high-performance access and communicates with the IBM i (iSeries, AS/400) to access, retrieve, and update DB2 data. All communication with the IBM DB2 for i server can also be optionally encrypted and authenticated via SSL v3.0 support.

Leveraging the IBM Optimized Database Server protocol standard, HiT OLEDB/400 uses native IBM server programs and does not require any additional software running on the IBM i platform. HiT OLEDB/400 supports all Windows 32-bit and 64-bit client platforms including Windows 7, Vista, XP, Windows 98/95, and Windows NT Workstation.
 

OLE DB, IBM i, iSeries, AS/400 client access
 

HiT OLEDB/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.

HiT OLEDB/400 supports OS versions V3R7 and later and can communicate over TCP/IP or APPC connections. To ensure high performance client applications, HiT OLEDB/400 supports the most flexible Windows 32-bit and 64-bit multi-threading models.

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

HiT OLEDB/400 database schema support is based on the ANSI SQL92 specification. Schema information is retrieved using predefined schema rowsets through the IDBSchemaRowset::GetRowset interfaces. Applications can specify simple restrictions, such as returning a particular table’s columns.

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 Toolbox provides powerful trace and debugging tools to help troubleshoot and optimize application performance, and convenient SQL package management.

HiT OLEDB/400 Developer Edition includes the C# toolkit and contains source code examples for accessing data using ADO.NET. The toolkit significantly cut application development time by providing developers with samples to query and update DB2 tables, control related OS subsystems, and retrieve DB2 data for redirection to 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 operating system, V3R7 or higher.

A server OLEDB provider, HiT OLEDB Server/400, is also available.
 

 
HiT OLEDB/400 Standard Edition
Standard Edition
Full Support
during Trial Period
HiT OLEDB/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 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
C# toolkit included with Developer Edition   Reduced development time


Supported DB2/400 Data Types
In rowsets and as parameter values, HiT OLEDB/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
BLOB   CLOB


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/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 Workstation Client
· Windows 7 (32-bit/64-bit), Windows XP, Windows Vista (32-bit/64-bit), Windows 98/95,
    Windows NT Workstation
· Support for TCP/IP or APPC network protocols
 
For the DB2 Server
· OS/400 or IBM i operating system V3R7 or higher

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

 

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