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

HiT ODBC/400 Dev. EditionDev. Edition


Purchase

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

as/400 iseries odbc driver for sql server : db2 connectivity


 
ODBC driver for IBM i, iSeries and AS/400  


Database Connectivity for IBM i

HiT ODBC/400 evaluation
Standard Edition

HiT ODBC/400
HiT ODBC/400 Developer Edition

HIGH PERFORMANCE ODBC DRIVER FOR IBM DB2 ACCESS
 
HiT ODBC/400 (for IBM i, iSeries or AS/400) is Windows SQL middleware for access to IBM DB2 servers running on IBM i, iSeries and AS/400 platforms. HiT ODBC/400 runs on Windows 7, Windows XP, Windows Vista, Windows 98/95, Windows NT Workstations, and is used by custom or third party product applications. It supports the Windows Open Database Connectivity (ODBC) standard to access, retrieve, and update DB2 data. All communication with the IBM i platform can also be optionally encrypted and authenticated via SSL with HiT SSL Server. Leveraging the IBM Optimized Database Server (ODBS) protocol standard, HiT ODBC/400 uses native IBM OS server programs and does not require any additional software running on the IBM i platform.

Improve performance with ODBC Level 3.x
 
HiT ODBC/400 supports full SQL functionality (via ODBC level 3.x conformance) for maximum performance of client applications. Functionalities include stored procedures, multiple result sets, static SQL/packages, multi-threading and dbExpress. ODBC level 3.x conformance 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/400 is particularly useful for developers working with custom applications. Silent installation support allows the middleware to be installed by calling custom setup applications. HiT Toolbox, included with the run-time middleware, is a sophisticated ODBC diagnostic tool for network administrators who need to resolve network issues. For developers, tracing and debugging tools enable examination and modification of SQL passed to the IBM DB2 for i server.

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

Security
 
HiT ODBC/400 can be used with HiT SSL Server, an all-Java, standards-based encryption and authentication server to secure SQL data flows over TCP/IP networks. It prevents unauthorized access to data by transparently enabling the Secure Socket Layer (SSL) protocol between HiT ODBC/400 and the system where HiT SSL Server is installed.

HiT ODBC/400 also supports IBM DB2 for i password expiration security. A read-only version driver is included for query-only client applications.

Developer Edition
 
In addition of the features supported by HiT ODBC/400, the developer edition includes the C# toolkit, with sample project/forms demonstrating working source code that connects, queries, retrieves, and updates DB2 data over ADO, and ODBCDirect.


ODBC AS/400 iSeries client access with HiT ODBC/400
 

HiT ODBC/400 Evaluation
Standard Edition
Full Support
during Trial Period
HiT JDBC/400 v1.x
Developer Edition
Full Support
during Trial Period

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
dbXpress   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
IBM 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
  Development time reduced

 
System Requirements:
 
Installation
· Windows 7 (32/64-bit), Vista(32/64-bit),XP, Windows 98/95, Windows NT Workstation
· Microsoft Data Access Components (MDAC) v2.5 or higher
 
Connectivity
· Support for TCP/IP and APPC network protocols
· NetManage NS/Router
· Microsoft SNA Server
· IBM Client Access
· IBM Personal Communications
· Wall Data RUMBA
· Attachmate APPC Client
· WRQ Reflection
 
Platform
· OS/400 V3R7 or higher
 

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   CLOB

 
HiT ODBC/400 Evaluation
Standard Edition
Full Support
during Trial Period
HiT JDBC/400 v1.x
Developer Edition
Full Support
during Trial Period

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