Overview and Specifications

ODBCLink/SE Reference Manual

ODBC Compliancy Level

ODBCLink/SE is ODBC Level 3 with the following exceptions:

SQLBrowseConnect, SQLExtendedFetch, SQLSetPos are not supported. Scalar Functions are not support.

SQL_BIT, SQL_TINYINT and SQL_BIGINT data types are not supported.

Client Environment

ODBCLink/SE and application software reside on the PC client. Using ODBCLink/ SE and applications software you can develop SQL applications, generate reports, and query ALLBASE/SQL or IMAGE/SQL on the database server. The tested client applications include:

Cognos Axiant

Cognos Impromptu

Jetform

Cold Fusion

Lotus 123

PowerBuilder

Crystal Reports

MSExcel

MSAccess

MSQuery

Visual Basic

Visual C++

Visual FoxPro

Paradox

and many more.

 

Server Environment

The networked HP 3000 Series 900 with ALLBASE/SQL and/or IMAGE/SQL or the HP9000 Series 7xx or 8xx with ALLBASE/SQL provide the relational database environment on the server. Security is provided by the MPE/iX or HP-UX logon system and ALLBASE/SQL or IMAGE/SQL.

The Connecting Link

ODBCLink/SE links the client to the server with a collection of dynamic link libraries (DLLs) and other files that reside on the client and run under Microsoft Windows95 and greater or Microsoft WindowsNT. ODBCLink/SE routes requests, made from the PC client application, over the network to an ALLBASE/SQL or IMAGE/SQL database on the database server, and returns replies to the client application.

A listener process establishes the connection between the PC client application and the target database on the server. The listener works with HP ThinLAN 3000/iX on the HP3000 or ARPA Services on the HP9000.

 

ODBCLink/SE

2

©M.B. Foster Associates Limited 1995-2000

Page 12
Image 12
HP MPE/iX 6.x Operating System manual Odbc Compliancy Level, Client Environment, Server Environment, Connecting Link