Manuals
/
Brands
/
Computer Equipment
/
Software
/
HP
/
Computer Equipment
/
Software
HP
MPE/iX 6.x Operating System manual
Please, tick the box below to download manual:
Contents
Version F.00
November
NOTICE
LIMITATIONS ON WARRANTIES AND LIABILITY
COPYRIGHT
ODBCLink/SE offers the following features:
The additional features of DataExpress for Client-Serverare:
Introducing MBF-Console
For monitoring and controlling ODBCLink/SE or MBF-UDALinkactivities such as:
If you require any of the following features:
FAX BACK
M. B. FOSTER ASSOCIATES LIMITED
NAME
TITLE
COMPANY
Page
Table of Contents
Chapter 6 Using ODBCLink/SE With ODBC Applications
Chapter 7 Troubleshooting
Appendix A Implementation Notes
Appendix B Creating a DBEnvironment
Appendix C List of Installed Files
Appendix D ODBCLink/SE Companion Product MBF-Console
Indexi
Page
Overview and Specifications
ODBC Compliancy Level
Client Environment
Server Environment
The Connecting Link
Microsoft ODBC Overview
ODBCLink/SE System Requirements
HP3000 Server Requirements:
HP9000 Server Requirements:
Client Requirements:
Field types supported:
SQL Commands supported:
Page
Preparing the Database Server
Verify Software Version Numbers
Verify the Connection Assurance Parameters
Starting and Stopping the Listener
To start the listener on the HP3000 data base server, enter:
To start the listener on the HP9000 database server, enter:
To determine whether or not the listener job is running:
To stop the listener:
Gather Information
Create the DBEnvironment
Installing ODBCLink/SE on the Client PC
Downloading ODBCLink/SE to the Client PC
Using Reflection® software:
Using ARPA Services (FTP):
Using NS Services (DSCOPY) on the HP3000:
Extracting the ODBCLink/SE file
Running the SETUP program
Page
Page
Page
Page
Notes on 32-bitAccess
Configuring Data Sources
Page
Select Continue when you are finished
Setup for MPE/iX
Setup for HP-UX
Setup Options
Select Translator
ODBC Translator
Successful Completion
Migrating HP PCAPI Data Sources
Application Development
Using Stored Procedures
Performance Considerations
Turning AutoCommit On/Off
Supported Functions
R2:
The following SQLSetConnectOptions are supported. All other will
return a “Driver not Capable (SQLState S1C00)”
Note: For information on isolation levels, refer to the "Isolation
Levels" section in this chapter
Isolation Levels
Supported Data Types
Note on Using BLOBs
Page
Using ODBCLink/SE With ODBC Applications
Updating Data
Using Cognos Impromptu
Special Notes for Users of Impromptu
Viewing the SQL generated by Impromptu
Joins
Changing the display format
Creating Joins Using Calculated Columns
Using Lotus 123 Release
Using Microsoft Access
Page
Notes for Users of MS-Access
Using MS-Query
Note: MS QUERY must be installed during the installation of
Microsoft Excel. Do a custom installation selecting MS
Query as one of the installed options
Using Visual Basic (4.0 or higher)
Connection Examples
Connect Using SQL API
Connect Using SQLAPI in VB
Page
Page
Connecting with DAO’s
Connecting with RDO’s
Connecting with ADO’s
Troubleshooting
Terminating an ODBC Connection
Using Microsoft ODBC Test (32-bit)
Verifying Software Version Numbers
Verifying the Client-SideComponents
Deleting a Translation DLL
Page
Tools on the Database Server
Monitoring Activity with HP GlancePlus/XL (HP3000) Program
Monitoring Activity with HP GlancePlus/UX (HP9000) Program
Displaying Active Processes with HP-UXProcess Status (ps) Command
Monitoring ALLBASE/SQL Activity with SQLMON
Page
Host Logging
Tools on the Client PC
ODBC Call Tracing using ODBCLink.LOG
ODBC Call Tracing using Dr. DeeBee Spy
To turn off logging:
Modifying the System Registry and ODBC.INI Files
Error Messages
Appendix A Implementation Notes
Primary key name returned by SQLStatistics
Reading or writing to ALLBASE/SQL LongVarBinary items
Maximum number of statements
ALLBASE/SQL and IMAGE/SQL Restrictions on the ODBC Grammar
Using the ANSI Character Set
Unsupported ALLBASE/SQL and IMAGE/SQL Statements
ALLBASE/SQL and IMAGE/SQL Statements That Work Only with Embedded SQL
ALLBASE/SQL and IMAGE/SQL Statements Replaced by Functions on the PC Client
Appendix B Creating a DBEnvironment
On the HP3000 Database Server
⊗Create the account where the DBEnvironment is to reside
⊗Grant authorizations to users who will be using the test DBEnvironment
⊗Create the DBEnvironment, including databases and tables
On the HP9000 Database Server
Page
Appendix C List of Installed Files
32 Bit Driver Client - For Windows 95 and Greater
Page
32 Bit Driver Client - For Windows NT 4.0 and Greater
Page
MPE/iX Host
HP-UX9.x Host
HP-UX10.x and 11.x Host
Page
Appendix D ODBCLink/SE Companion Product MBF-Console
MBF-ConsoleIntroduction
How MBF-ConsoleWorks
Running MBF-Console
File Menu Options
Set Refresh Interval (in seconds)
Page Setup
Print
Exit
Connect Menu Options:
Configure DSNs... (Console Data Sources Configuration)
Connections Windows
The Listener Window
The Connections Window
Server Window:
⊗ODBCLOG Setting
⊗Client Version
⊗Statistics for Time Period
⊗Time of Last Server Activity Reported
⊗Bytes Received
“View” Menu Option
“Window” Menu Option
Help Menu Options:
Installing MBF-Consolefor MBF-UDALink
Note: Ensure the Transfer Type is Binary
from
File Transfer in Process
Type: C:\MBFOSTER\ODBCCONS.EXE and press OK
Select: Start, Run. The Run window is displayed, as above
If you are installing from a CD
If you followed the tape installation instructions
Type: C:\MBFOSTER\SETUP.EXE in the command field
Page
Page
Page
Page
Page
Installing MBF-Consolefor ODBCLink/SE
Select:
NEXT
Page
Page
Page
Page
Page
Page
Index
Implementation Notes
Listener - Starting and Stopping
Setup
Tools on Database Server
Tools on the PC Client
Translation DLL
25
Checking Listener Log File
Winsock