HiT ODBC Server/400
HiT ODBC Server/400 Developer Edition

HIGH PERFORMANCE ODBC DRIVER FOR WINDOWS SERVERS
 
HiT ODBC Server/400 (ODBC for System i, i5, iSeries or AS/400) is Windows SQL middleware access to IBM DB2 servers running on System i, iSeries and AS/400 platforms. HiT ODBC Server/400 accepts standard Windows Open Database Connectivity (ODBC) function calls, translates these into native DB2/400 SQL for high-performance, and communicates with the AS/400 to access, retrieve, and update DB2/400 data. All communication with the AS/400 can also be optionally encrypted and authenticated via SSL v3.0 support. Leveraging the IBM Optimized Database Server protocol standard, HiT ODBC Server/400 (ODBC for iSeries or AS/400) uses native IBM server programs and does not require any additional AS/400 software.
 
The HiT Server Manager allows a remote developer or administrator to see ODBC connections by DB2 server, calling application and user ID, start time of connections, status of connection, traffic volume over connection, and memory utilization. DB2 server connections can be pooled and reused to optimize performance. The HiT Server Manager can define the time-out and dropping of these pooled connections. Developer and administrators can now monitor the DB2 middleware access layer to ensure maximum Windows server application performance.
 
HiT ODBC Server/400 supports full SQL functionality (via ODBC level 3.5 conformance) for maximum application performance including stored procedures, multiple result sets, and static SQL/packages. Multi-threading support ensures high performance for client applications. Its unique dbXpress performance feature also significantly speeds applications. ODBC level 3.5 compliance offers developers powerful new data access techniques, catalog functionality, access to environmental attributes, extended data types, SQL batch support, error reporting, and ANSI SQL-92 alignment.

HiT ODBC Server/400 is particularly useful for developers working with custom applications. HiT Toolbox, included with the run-time middleware, is a sophisticated ODBC diagnostic tool and gives network administrators specific tools to resolve network issues. For developers, tracing and debug tools allow examination and modification of SQL passed to the DB2/400 server. HiT ODBC Server/400 also includes HiT DataAccess/OCX, an ActiveX control that provides developers with easy, fast and reliable DB2/400 access from Visual Basic and other development tools.

A Developer Edition of HiT ODBC Server/400 is available and includes Active Server Page and Visual Basic toolkits with sample applications and project/forms demonstrating working source code that connects, queries, retrieves, and updates DB2 data over ADO.
 
HiT ODBC Server/400 can be used with all major application development tools that support the Windows ODBC standard. Additionally, hundreds of third-party software products can use HiT ODBC/400 for business intelligence, decision support, query/reporting, data replication, and data mining. Support is also included for the most common AS/400 single and double character sets. As sixth generation middleware, HiT ODBC Server/400 v6.1 is extremely reliable and has evolved a robust feature set.
 

For high-security applications, data encryption and server authentication services can be enabled using HiT SSL Server, a secure server that uses the Secure Sockets Layer Protocol. HiT ODBC Server/400 also supports DB2/400 password expiration security.

HiT ODBC Server/400 includes extensive on-line documentation covering ODBC data source configurations, ODBC functions, SQL grammer, using DB2/400 stored procedures, static SQL/package use, tracing, debugging, and diagnostics.

HiT ODBC Server/400 supports the following database standards: ODBC core and level 3 conformance, ANSI SQL-92, X/Open and ISO CLI catalog function column name standards, ADO, RDO, DAO, and ODBCDirect. For networks, HiT ODBC Server/400 supports multiple connectivity transports to DB2/400 servers including TCP/IP and SNA/APPC.

Key Features			Benefits
ODBC level 3.x conformance ADO level 2.x compliance .NET framework 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/400 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
OS/400 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			Remote monitoring management
ASP and VB toolkit included with Developer Edition			Development time reduced

 
System Requirements:
 
For the Windows Server
· Windows Server 2003 (32/64 bit), Windows Server 2000
  or Windows NT Server 4.0
· 12Mb Disk Space
· Network card operable with network protocols
· TCP/IP or APPC conncection to the AS/400
 
For the DB2 Server
· OS/400 V3R1 through IBM i 6.1 (i5/OS V6R1)
 
Connectivity
· TCP/IP
· NetManage NS/Router
· Microsoft SNA Server
· IBM Client Access
· IBM Personal Communications
· Wall Data RUMBA
· Attachmate APPC Client
· WRQ Reflection
 

Supported Data Types
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			GRAPHIC
CLOB			BIGINT
TINYINT			BIT
DOUBLE PRECISION			BINARY
VAR BINARY			LONG VAR BINARY