HP MPE/iX 6.x Operating System manual Tools on the Client PC, Odbc Call Tracing using ODBCLink.LOG

Page 73

ODBCLink/SE Reference Manual

Troubleshooting

Tools on the Client PC

The preferred method to trace ODBC calls on the client is by setting the “Trace ODBC Calls” check box in ODBC setup. However, Syware’s Dr. DeeBee Spy is installed with ODBCLink/SE (in the Windows directory). It can be used to trace calls to any ODBC driver.

ODBC Call Tracing using ODBCLink.LOG

To log all the ODBC calls made by the client, check the box “Trace ODBC calls on the client” on the data-source setup screen. This will create a file, called ODBCLINK.LOG, of all the ODBC calls made by the client. This file normally resides in the directory where the ODBC application was started from. Some applications however change their working directory, for MS-Access for instance look for the log file in “My Documents” directory.

Here is the format of the ODBCLINK.LOG file:

SQLDriverConnect(0) hstmt=0 Ver= 5.52.0000 szConnStrIn=<DSN=DBA MEMBER; UID=Admin; PWD=>,Completed_string=<DSN=DBA MEMBER; UID=#mpeix/192.9.3.10:MembrDBE.SQL.mbftest,,an# DBA,dba/.MBFTEST/ password,work/> Login=<>

SQLError(100) hstmt=0 pfNativeError=0,szErrorMsg= SQLGetInfo(0) hstmt=0 fInfoType=23, rgbInfoValue= [1,0,0,0] SQLSetConnectOption(0) hstmt=0 fOption=101 vParam=1 SQLAllocStmt(0) hstmt=0

SQLGetStmtOption(0) hstmt=0 fOption=0 vParam=0 SQLSetStmtOption(-1) hstmt=0 fOption=0 vParam=60

SQLError(0) hstmt=0 pfNativeError=-57,szErrorMsg=[ODBCLN32.DLL] Driver not capable

SQLError(100) hstmt=0 pfNativeError=0,szErrorMsg=

SQLExecDirect(0) hstmt=0 SELECT MEMBERDB.ACCTHIST.NUMBER,MEMBERDB.ACCTHIST.TRANTYPE,MEMB ERDB.ACCTHIST.

TRANDATE FROM MEMBERDB.ACCTHIST

SQLFetch(0) hstmt=0

SQLGetData(0) hstmt=0 icol=1 fCType=99 pcbValue=4 data= '[25,39,0,0]

SQLGetData(0) hstmt=0 icol=2 fCType=99 pcbValue=3 data=INV[73,78,86,0]

SQLGetData(0) hstmt=0 icol=3 fCType=99 pcbValue=6 data=È [-56,7,1,0]

Each line starts with the name of the function being called, with the return code in brackets, followed by the different parameters of the call. Refer to the ODBC SDK manual for a description of the parameters of the call.

ODBC Call Tracing using Dr. DeeBee Spy

Dr. DeeBee Spy traces calls to the ODBC driver. Dr. DeeBee Spy logs each function call along with the input and output values. To turn on logging, do the following:

⊗From the Program Manager Menu in Windows, click on RUN.

⊗Type DRDBSP.

⊗Choose OK.

⊗Select the Data Source Name to be traced.

⊗Choose OK.

ODBCLink/SE

 

©M.B. Foster Associates Limited 1995-2000

63

Page 72 Page 74
Image 73
Page 72 Page 74
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 EnvironmentMicrosoft Odbc Overview HP3000 Server Requirements ODBCLink/SE System RequirementsHP9000 Server Requirements Client RequirementsField types supported SQL Commands supportedPage Verify the Connection Assurance Parameters Verify Software Version Numbers$sqlver ExitStarting 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, enterTo stop the listener To determine whether or not the listener job is running# ps -ef grep odbclnse Create the DBEnvironment Gather InformationDownloading ODBCLink/SE to the Client PC Using Reflection softwareUsing 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 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 =All Rows default =ON default 0=OFF=No Timeout default Use Allbase TimeoutIsolation 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 ImpromptuChanging the display format JoinsException tables Joined=T 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 Connect Using Sqlapi in VB Connect Using SQL APIExample DSN=YOUR DSNUID=USERPWD=PASSWORD Connection ExamplesODBCLink/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 Tools on the Database Server Using the Host Testing Utility OdbcutseMonitoring ALLBASE/SQL Activity with Sqlmon Checking the Listener Log File on the HP3000Execute immediate SQL command SQL UpdateExecute stored procedure Display tables and table structuresHost 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 loggingModifying 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 driverReading 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 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 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 ExitListener Window Connections WindowsConnections 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