Microsoft Odbc Overview | HP MPE/iX 6.x Operating System specs

ODBCLink/SE Reference Manual

Overview and Specifications

Microsoft ODBC Overview

ODBC applications make functions calls into ODBC32.DLL, the Microsoft driver manager. Since a single application can make calls to more than one ODBC database (e.g. Sybase, Microsoft SQL server) the driver manager is in charge of routing ODBC calls to the appropriate driver. The ODBC.INI file contains a list of drivers and associated data sources (one driver may have several data-sources). In Windows 95 or NT, some of this information is kept in the system registry.

To connect to an ODBC database, you call SQLDriverConnect (or you let your ODBC-compliant application call it for you) and specify your data-source name in the connection string variable, which is in the form "DSN=data_source”. The driver manager reads ODBC.INI or the registry, to find out which driver handles that data source and passes the call on to the driver. The driver opens the communication channel and does all necessary initialization.

The ODBC.INI file (or the ODBC System Registry) is maintained through the ODBC Control Panel application ODBCADM.EXE , or the 32-bit ODBC Control Panel application ODBCAD32.EXE. The control panel application will call the setup DLL for the driver it is accessing ODBCLS32.DLL, in the case of ODBCLink/SE, which will update ODBC.INI or the system registry.

ODBCLink/SE
©M.B. Foster Associates Limited 1995-2000	3

Image 13

HP MPE/iX 6.x Operating System manual Microsoft Odbc Overview

Contents

ODBCLink/SETM Limitations on Warranties and Liability Additional features of DataExpress for Client-Server are ODBCLink/SE offers the following featuresSales@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 LinkClient Environment Server Environment Microsoft Odbc Overview HP3000 Server Requirements ODBCLink/SE System RequirementsHP9000 Server Requirements Client Requirements Field types supported SQL Commands supportedPage Verify the Connection Assurance Parameters Verify Software Version Numbers$sqlver Exit Starting and Stopping the Listener F1 Open ConfigTo 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 JoinsException 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 APIExample 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 OdbcutseMonitoring ALLBASE/SQL Activity with Sqlmon Checking the Listener Log File on the HP3000 Execute immediate SQL command SQL UpdateExecute stored procedure Display tables and table structures Host Logging Odbc Call Tracing using Dr. DeeBee Spy Odbc Call Tracing using ODBCLink.LOGTools 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 MessagesGenerated by the 32-bit client DLL Comes from the Winsock driver Reading or writing to ALLBASE/SQL LongVarBinary items Primary key name returned by SQLStatisticsMaximum 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 HostHP-UX 10.x and 11.x Host Page How MBF-Console Works MBF-Console IntroductionRunning MBF-Console File Menu Options SetupSet Refresh Interval in seconds Connect Menu Options Configure DSNs... Console Data Sources ConfigurationPrint Exit Listener Window Connections WindowsConnections 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