HP MPE/iX 6.x Operating System manual Installing MBF-Console for ODBCLink/SE

Page 107

ODBCLink/SE Reference Manual

Appendix D ODBCLink/SE Companion Product

Installing MBF-Console for ODBCLink/SE

In order to test the console product, M. B. Foster has set up an environment where you can run a second listener while still keeping any older version still running. This is accomplished by utilizing a second socket identifier. This will give an opportunity to test out the new version and to evaluate the MBFConsole product. The MBFConsole product will not work with versions of ODBCLink/SE older then version E.57.

The following are instructions for installing the current version of the ODBCLink/SE software, F.00. The material may come from one of two sources; on tape directly from M B Foster or through the M B Foster web site. When you receive the file from the web site it will be in a single compressed file. This file will contain the 32-bit client, the console client, and the host files for both MPE and Unix and command files to help do the install. This file is a self- extracting zip file. Create a new directory called MBFOSTER to be used for the file extract. This can be done using MS Explorer.

If you are installing on an MPE host:

⊗Use your terminal emulator to log on to your host and log on as MANAGER.SYS..

⊗You will be creating a new group MBFOSTER.SYS that will contain the host files.

⊗If your are using Reflection, execute the RCL file UPLOAD3K.RCL.

⊗If your are running Minisoft, execute the script file UPLOAD3K.S92

If you are installing on an Unix host

⊗Use your terminal emulator to log on to your host and log on as root

⊗You will be creating a new directory /opt/mbfoster/odbcse that will contain the host files.

⊗If your are using Reflection, execute the RCL file UPLOADUX.RCL.

⊗If your are running Minisoft, execute the script file UPLOADUX.S92

⊗Follow the instructions for installing the ODBC client.

⊗Follow the instructions for installing the MBFConsole.

When a tape is received all the files will be on the tape. Follow the instructions for restoring the tape. You will restore the host files and then follow the instructions for downloading and installing the ODBC client and MBFConsole.

Note: If you are installing a demo version of MBF-Console, enter c:\mbfoster\democons.exe. The demo version will remain active for 45 days after it has been installed. A demo version can be downloaded from the MBFoster web page, www.mbfoster.com, under Products. The demo version obtained from the web page can be installed by running democons.exe from the Run option of the Windows 95, Windows 98 or Windows NT Start button.

Select: Start, Run. The Run window is displayed.

Type: C:\MBFOSTER\ODBCCONS.EXE and press OK

ODBCLink/SE

 

©M.B. Foster Associates Limited 1995-2000

97

Page 106 Page 108
Image 107
Page 106 Page 108
Contents ODBCLink/SETM Limitations on Warranties and Liability Sales@mbfoster.com ODBCLink/SE offers the following featuresAdditional features of DataExpress for Client-Server are 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 Server Environment Connecting LinkOdbc Compliancy Level Client EnvironmentMicrosoft Odbc Overview Client Requirements ODBCLink/SE System RequirementsHP3000 Server Requirements HP9000 Server RequirementsField types supported SQL Commands supportedPage Exit Verify Software Version NumbersVerify the Connection Assurance Parameters $sqlverTo start the listener on the HP9000 database server, enter F1 Open ConfigStarting and Stopping the Listener To start the listener on the HP3000 data base server, enter# ps -ef grep odbclnse To determine whether or not the listener job is runningTo stop the listener Create the DBEnvironment Gather InformationDownloading ODBCLink/SE to the Client PC Using Reflection software\ODBCSEnn ftp Server binary Get odbcclnn odbcclnn.exe quit Using Arpa Services FTPUsing NS Services Dscopy on the HP3000 Extracting the ODBCLink/SE file Running the Setup programSelect 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/PartsDBESetup for MPE/iX Setup for HP-UX Setup Options Successful Completion Select Translator Odbc TranslatorMigrating HP Pcapi Data Sources Application Development ?=call owner.procedue ?,? Using Stored ProceduresPerformance Considerations Turning AutoCommit On/Off Supported Functions Timeout =ON default 0=OFF=All Rows default =No Timeout default Use AllbaseIsolation Levels Sqldecimal Supported Data TypesDate Sqldate Page Updating Data Using ODBCLink/SE With Odbc ApplicationsUsing Cognos Impromptu Viewing the SQL generated by Impromptu Special Notes for Users of ImpromptuException tables Joined=T JoinsChanging the display format Column3 = .column1 + .Column2 Creating Joins Using Calculated ColumnsDN=@ODBC@ DL=@DLODBC@ DD=@All Odbc Sources@ Using Lotus 123 ReleaseUsing Microsoft Access ODBCLink/SE ODBCLink/SE Foster Associates Limited Using MS-Query ODBCLink/SE Foster Associates Limited Using Visual Basic 4.0 or higher Connection Examples Connect Using SQL APIConnect Using Sqlapi in VB Example DSN=YOUR DSNUID=USERPWD=PASSWORDODBCLink/SE ODBCLink/SE Foster Associates Limited Open the Table and Enter the SQL Query Connecting with DAO’sConnecting with RDO’s Connecting with ADO’s Terminating an Odbc Connection TroubleshootingTo run ODBCTE32.EXE Using Microsoft Odbc Test 32-bitVerifying the Client-Side Components Verifying Software Version NumbersDeleting a Translation DLL ODBCLink/SE Reference Manual Troubleshooting Checking the Listener Log File on the HP3000 Using the Host Testing Utility OdbcutseTools on the Database Server Monitoring ALLBASE/SQL Activity with SqlmonDisplay tables and table structures SQL UpdateExecute immediate SQL command Execute stored procedureHost Logging Tools on the Client PC Odbc Call Tracing using ODBCLink.LOGOdbc Call Tracing using Dr. DeeBee Spy Log is located in C\WINDOWS\DRDEEBEE.LOG To turn off loggingModifying the System Registry and ODBC.INI Files Comes from the Winsock driver Error MessagesGenerated by the ALLBASE/SQL command interpreter Generated by the 32-bit client DLLInsert Into Table Values ..., Blob %$ Primary key name returned by SQLStatisticsReading or writing to ALLBASE/SQL LongVarBinary items Maximum number of statementsALLBASE/SQL and IMAGE/SQL Restrictions on the Odbc Gram- mar Using the Ansi Character SetUnsupported ALLBASE/SQL and IMAGE/SQL Statements Appendix a Implementation Notes ODBCLink/SE Reference Manual On the HP3000 Database Server Appendix B Creating a DBEnvironmentUp,down,left,right,top,bottom,printn,or end Isql= exit On the HP9000 Database Server $ csh /usr/lib/allbase/hpsql/sqlsetupODBCLink/SE Bit Driver Client For Windows 95 and Greater Appendix C List of Installed FilesODBCLink/SE Bit Driver Client For Windows NT 4.0 and Greater Install Disc Windows NT DescriptionODBCLink/SE HP-UX 10.x and 11.x Host MPE/iX HostHP-UX 9.x Host Page Running MBF-Console MBF-Console IntroductionHow MBF-Console Works Set Refresh Interval in seconds SetupFile Menu Options Exit Configure DSNs... Console Data Sources ConfigurationConnect Menu Options PrintConnections Window Connections WindowsListener Window Server Window ⊗ Stop Logging Window Menu Option View Menu OptionHelp Menu Options This can be done using MS Explorer Installing MBF-Console for MBF-UDALinkODBCLink/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
Top Page Image Contents