Contents
ODBCLink/SETM
Limitations on Warranties and Liability
Additional features of DataExpress for Client-Server are
ODBCLink/SE offers the following features
Sales@mbfoster.com
If you require any of the following features
Page
Page
Table of Contents
Using ODBCLink/SE With Odbc Applications
Appendix B Creating a DBEnvironment
Page
Overview and Specifications
Odbc Compliancy Level
Connecting Link
Client Environment
Server Environment
Microsoft Odbc Overview
HP3000 Server Requirements
ODBCLink/SE System Requirements
HP9000 Server Requirements
Client Requirements
Field types supported
SQL Commands supported
Page
Verify the Connection Assurance Parameters
Verify Software Version Numbers
$sqlver
Exit
Starting and Stopping the Listener
F1 Open Config
To start the listener on the HP3000 data base server, enter
To start the listener on the HP9000 database server, enter
To stop the listener
To determine whether or not the listener job is running
# ps -ef grep odbclnse
Create the DBEnvironment
Gather Information
Downloading ODBCLink/SE to the Client PC
Using Reflection software
Using NS Services Dscopy on the HP3000
Using Arpa Services FTP
\ODBCSEnn ftp Server binary Get odbcclnn odbcclnn.exe quit
Extracting the ODBCLink/SE file
Running the Setup program
Select Next
ODBCLink/SE Foster Associates Limited
Page
Page
ODBCLink/SE
Configuring Data Sources
Scroll down to ODBCLink/SE-32 Driver ODBC3. Click Finish
MPE/iX if it is an HP3000 HP-UX if it is an HP9000
Usr/users/data/PartsDBE
Setup for MPE/iX
Setup for HP-UX
Setup Options
Successful Completion
Select Translator Odbc Translator
Migrating HP Pcapi Data Sources
Application Development
?=call owner.procedue ?,?
Using Stored Procedures
Performance Considerations
Turning AutoCommit On/Off
Supported Functions
=All Rows default
=ON default 0=OFF
=No Timeout default Use Allbase
Timeout
Isolation Levels
Sqldecimal
Supported Data Types
Date Sqldate
Page
Updating Data
Using ODBCLink/SE With Odbc Applications
Using Cognos Impromptu
Viewing the SQL generated by Impromptu
Special Notes for Users of Impromptu
Changing the display format
Joins
Exception tables Joined=T
Column3 = .column1 + .Column2
Creating Joins Using Calculated Columns
DN=@ODBC@ DL=@DLODBC@ DD=@All Odbc Sources@
Using Lotus 123 Release
Using Microsoft Access
ODBCLink/SE
ODBCLink/SE Foster Associates Limited
Using MS-Query
ODBCLink/SE Foster Associates Limited
Using Visual Basic 4.0 or higher
Connect Using Sqlapi in VB
Connect Using SQL API
Example DSN=YOUR DSNUID=USERPWD=PASSWORD
Connection Examples
ODBCLink/SE
ODBCLink/SE Foster Associates Limited
Open the Table and Enter the SQL Query
Connecting with DAO’s
Connecting with RDO’s
Connecting with ADO’s
Terminating an Odbc Connection
Troubleshooting
To run ODBCTE32.EXE
Using Microsoft Odbc Test 32-bit
Verifying the Client-Side Components
Verifying Software Version Numbers
Deleting a Translation DLL
ODBCLink/SE Reference Manual Troubleshooting
Tools on the Database Server
Using the Host Testing Utility Odbcutse
Monitoring ALLBASE/SQL Activity with Sqlmon
Checking the Listener Log File on the HP3000
Execute immediate SQL command
SQL Update
Execute stored procedure
Display tables and table structures
Host Logging
Odbc Call Tracing using Dr. DeeBee Spy
Odbc Call Tracing using ODBCLink.LOG
Tools on the Client PC
Log is located in C\WINDOWS\DRDEEBEE.LOG
To turn off logging
Modifying the System Registry and ODBC.INI Files
Generated by the ALLBASE/SQL command interpreter
Error Messages
Generated by the 32-bit client DLL
Comes from the Winsock driver
Reading or writing to ALLBASE/SQL LongVarBinary items
Primary key name returned by SQLStatistics
Maximum number of statements
Insert Into Table Values ..., Blob %$
ALLBASE/SQL and IMAGE/SQL Restrictions on the Odbc Gram- mar
Using the Ansi Character Set
Unsupported ALLBASE/SQL and IMAGE/SQL Statements
Appendix a Implementation Notes ODBCLink/SE Reference Manual
On the HP3000 Database Server
Appendix B Creating a DBEnvironment
Up,down,left,right,top,bottom,printn,or end Isql= exit
On the HP9000 Database Server
$ csh /usr/lib/allbase/hpsql/sqlsetup
ODBCLink/SE
Bit Driver Client For Windows 95 and Greater
Appendix C List of Installed Files
ODBCLink/SE
Bit Driver Client For Windows NT 4.0 and Greater
Install Disc Windows NT Description
ODBCLink/SE
HP-UX 9.x Host
MPE/iX Host
HP-UX 10.x and 11.x Host
Page
How MBF-Console Works
MBF-Console Introduction
Running MBF-Console
File Menu Options
Setup
Set Refresh Interval in seconds
Connect Menu Options
Configure DSNs... Console Data Sources Configuration
Print
Exit
Listener Window
Connections Windows
Connections Window
Server Window
⊗ Stop Logging
Window Menu Option
View Menu Option
Help Menu Options
This can be done using MS Explorer
Installing MBF-Console for MBF-UDALink
ODBCLink/SE
ODBCLink/SE Foster Associates Limited
Select Next
ODBCLink/SE Foster Associates Limited
When you have decided, press Next
ODBCLink/SE Foster Associates Limited
Select Finish to complete the Setup
Installing MBF-Console for ODBCLink/SE
Next
ODBCLink/SE Foster Associates Limited
100 Foster Associates Limited
ODBCLink/SE Foster Associates Limited 101
102 Foster Associates Limited
Page
Page
Index
Index ODBCLink/SE Reference Manual
ODBCLink/SE Reference Manual Index Listener Log File HP9000
Using Process Status ps Command
ODBCLink/SE Reference Manual Index
