Neoview ODBC Drivers Manual (R2.5)

1 HP Neoview ODBC Driver Overview for Windows
Open Database Connectivity (ODBC) is a widely accepted application programming interface
(API) for database access. It is based on the Call-Level Interface (CLI) specifications from X/Open
and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access
language.
ODBC is designed for maximum interoperability — that is, the ability of a single application to
access different database management systems (DBMSs) with the same source code. Database
applications call functions in the ODBC interface, which are implemented in database-specific
modules called drivers. The use of drivers isolates applications from database-specific calls in
the same way that printer drivers isolate word processing programs from printer-specific
commands. Because drivers are loaded at run time, you only have to add a new driver to access
a new DBMS; it is not necessary to recompile or relink the application.
This section describes:
• “Driver Components”
• “Data Sources”
• “Connections”
• “Object Naming and Mapping”
• “Passwords and Server Certificates” (page 18)
• “Release Considerations and Restrictions”
• “Traces”
• “Neoview Platform Specific Extensions and Attributes” (page 25)
• “INFOSTATS Command ”
• “Unsupported ODBC API Functions and Data Types”
Driver Components
Driver components can be installed on any workstation running Windows 2000, Windows 2000
Server, Windows 2003 Server, Windows XP. These are the driver components:
An ODBC-enabled application that you can use to test
ODBC drivers.
ODBC test application
Manages access to ODBC drivers for applications. The
driver manager loads and unloads drivers and passes calls
for ODBC functions to the correct driver.
Microsoft ODBC 3.51 (or later) driver manager
Implements ODBC function calls (a subset of the ODBC
3.51 API), to enable an ODBC client application to access
the Neoview database.
HP Neoview ODBC driver
Manages database drivers and data sources.Microsoft ODBC Administrator
Drivers Supported
The HP Neoview ODBC Driver for Windows supports either 32-bit or 64-bit drivers, depending
on the operating system:
Operating SystemDriver
Microsoft Windows 2000, Windows 2003, or Windows
XP
32–bit driver
x64 Editions of Windows XP or Windows 200364–bit driver
Driver Components 15