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

pdf HiT ODBC Server/DB2 Dev. EditionDev. Edition


Purchase

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

ODBC Driver for DB2 SQL Server : database connectivity : db2 luw


 
ODBC driver for IBM DB2 servers running on DB2 UDB and DB2 LUW  


Database Connectivity for DB2 LUW

HiT ODBC Server/DB2 evaluation
Standard Edition

HiT ODBC Server/DB2
HiT ODBC Server/DB2 Developer Edition

HiT ODBC Server/DB2 (for DB2 for LUW or for DB2 for z/OS) provides a secure, centralized, Open Database Connectivity (ODBC) service for Windows Server applications and for ODBC client applications. HiT ODBC Server/DB2 enables Windows Server software, such as Microsoft IIS, access to DB2 data and thereby to clients of the server software. HiT ODBC Server/DB2 enables NT Server software, such as Microsoft IIS, access to DB2 data and thereby to clients of the server software.

HiT ODBC Server/DB2 Developer Edition (DE) includes the C# Toolkit. It contains source code examples for accessing data using ADO.NET. It significantly cuts application development time by providing developers working C# samples to query and update DB2 tables 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.

Key Features   Benefits
ODBC level 3.x conformance
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
 
Legacy DB2 LUW and UDB Support   Flexible deployment
Debug/trace tools   Fast diagnostics
Silent install support   Fewer IT support issues during deployment
TCP/IP or APPC 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 and C# Toolkit
with Developer Edition
  Remote monitoring management and
reduced development time

Security
 
HiT ODBC Server/DB2 allows an administrator to pre-define data sources for server and downstream Windows clients. These data sources are maintained at the server and cannot be modified. The included HiT ODBC thin client only communicates with the ODBC server, providing a security gateway before the DB2 host server.

Configurations
 
HiT ODBC Server/DB2 can be used in two configurations:
 
· Server ODBC Applications
 
  A Windows NT server application or service locally uses the ODBC service to access DB2 data and
  redirect it where necessary. For example, using the Microsoft IIS web server and Active Server
  Pages, downstream web browser clients can access DB2 data.
 

Server ODBC DB2 UDB and DB2 LUW Applications Schematic

· Client ODBC Applications
 
  A thin client presents the ODBC API to a Windows client application and transports the ODBC
  commands to the ODBC service. Only server-defined data sources are available to client ODBC
  applications. For example, a custom Visual Basic application uses the thin client ODBC API to
  access DB2 data via the ODBC service.
 

Client ODBC DB2 UDB and DB2 LUW Applications Schematic

 
Server 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
· TCP/IP or APPC connection to the DB2 Server
 
DB2 LUW (Linux, UNIX, Windows)
· DB2 version 5.0 or later
 
DB2 for i (iSeries, AS/400)
· IBM OS/400 Operating System V3R7 or higher
 
DB2 for z/OS (OS/390)
· DB2 for OS/390 version 5.0, or above

HiT ODBC Server/DB2 evaluation
Standard Edition
Full Support
during Trial Period
HiT ODBC Server/DB2 Developer Edition Evaluation
Developer Edition
Full Support
during Trial Period


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