HiT Software : relational database middleware for web and client/server applications
Buy Download Contact Us

Chinese Website 
Japanese Website 


db2 connectivity
Products Overview
DBMoto Replication
DB2 Connectivity
Allora Database
XML Mapping
SafeConduct
Data Security
XML Utilities
Downloads
White Papers
Case Studies
and Testimonials
oledb provider : db2 connectivity

HiT OLEDB Server/DB2
HiT OLEDB Server/DB2 Developer Edition

HiT OLEDB Server/DB2 (for OLE DB DB2 or mainframe) is Windows client middleware for DB2 SQL access from custom applications and third party products. HiT OLEDB Server/DB2 accepts application SQL commands via ADO v2.x or directly via its object properties and methods. It then translates these into native DB2 SQL for high-performance, communicates with the DB2 server to access, retrieve, and update data. All communication with the DB2 server can also be optionally encrypted and authenticated via SSL v3.0 support. Leveraging the IBM Distributed Relational Database Architecture protocol standard, HiT OLEDB Server/DB2 (for OLE DB DB2 or mainframe) uses native IBM server programs and does not require any additional DB2 server software. HiT OLEDB Server/DB2 supports all Windows 32-bit client platforms including Windows 2000 and NT Server.

sql server ole db provider for ibm db2
 

HiT OLEDB Server/DB2 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 Server/DB2 can communicate over TCP/IP or SNA connections.

OLEDB provider support includes data source, session, transaction, command, rowset, and error COM objects. (Distributed transactions are supported for TCP/IP connections to the mainframe and will be supported on other platforms when DB2 v7 becomes available.) A complete set of data type mapping between DB2/400 and OLE DB/ADO environments is supported and documented.

HiT OLEDB Server/DB2 database schema support is based on the ANSI SQL92 specification. Schema information retrieved using predefined schema rowsets via IDBSchemaRowset::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 v2.0 connection pooling. ADO v2.0 connection pooling, as an OLE DB v2.0 consumer, is therefore also supported.

The included OLEDB Workshop allows easy data link definition and diagnostics. Additionally, it provides powerful trace and debugging tools to help troubleshoot and optimize application performance, and convenient SQL package management.

HiT OLEDB Server/DB2 Developer Edition (DE) includes the HiT Active Server Page and Visual Basic Toolkits. These contain source code examples for accessing data using ActiveX Data Objects 2.0 (ADO). It significantly cuts application development time by providing developers working ASP code and VB samples to query and update DB2 tables and retrieve DB2 data for redirection to applications. Included source code demonstrates connections using ADO recordsets, executing stored procedures, retrieving table data, inserting table data, and displaying results.

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

Key Features   Benefits
ADO level 2.x 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 DB2 server version support   Flexible deployment
Debug/trace tools   Fast diagnostics
Silent install support
 
  Fewer IT support issues
during deployment
TCP/IP or SNA connectivity support   Common network transport
Double-byte support
 
  International DB2 server
access
DRDA 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
 
  Remote monitoring
management
ASP and VB toolkit included with
Developer Edition
  Development time reduced
 

Supported DB2/400 Data Types
 
In rowsets and as parameter values, HiT OLEDB Server/400 maps DB2/400 data types to OLE DB-defined data types. The following DB2/400 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 Workstation Client
Pentium processor; does not have to be a dedicated PC
Windows NT Server 4.0 and later
32MB Memory
12MB Disk Space
Ethernet card operable with TCP/IP network protocols
Microsoft Internet Information Server (for ODBC Thin Client
  Applications)
TCP/IP or APPC connection to the DB2 Server
 
Server Requirements:
 
For the Windows Server
Windows Server 2003 (32/64 bit), Windows Server 2000 or
  Windows NT Server 4.0
 
For the DB2 Server
OS/390
    DB2 UDB v5 or later
MVS Requirements
    DB2 UDB v5 or later
    MVA/XA or MVS/ESA
    VTAM® 3.3 or later
VM Requirements
    SQLDS® v3.4 or later
    VM/SP Release 6 or later
    VM ESA Release 1
    VTAM® 3.2 or later
NT/OS2/AIX/DB2 Server
    DB2 UDB v5 or later
OS/400
    DB2 OS/400 v2r2 or later
    TCP/IP supported from OS/400 v4r2 or later
 

Product Resources:

Download an evaluation
   HiT OLEDB Server/DB2
   HiT OLEDB Server/DB2
           Developer Edition

HiT VB Toolkit/OLEDB
   (Product Preview)

DB2 Connectivity Overview
   PDF Format

Case Studies

White Papers

Buy


All Rights Reserved 2008 HiT Software, Inc.
All other trademarks or registered trademarks herein are the property of their respective owners.