ODBCLINK/SE Reference Manual (36217-90410)

Overview and Specifications ODBCLink/SE Reference Manual
ODBCLink/SE
2 ©M.B. Foster Associates Limited 1995-2000
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.