HP MPE/iX 6.x Operating System manual Bit Driver Client For Windows NT 4.0 and Greater

Page 87

ODBCLink/SE Reference Manual

Appendix C List of Installed Files

32 Bit Driver Client - For Windows NT 4.0 and Greater

NOTE: “..\” is a short-hand that represents the location of the windows installation (e.g. c”\windows\”)


		Install Disc	Windows NT	Description


		_bootstp.exe	not installed to hard drive

		_mssetup.ex_	not installed to hard drive

		b5ccdc32.dl_	..\system32\b5ccdc32.dll	Used for character translation for Chinese characters

		ctl3dnt.dl_	..\system32\ctl3dnt.dll	DLL for 3D controls in WindowsNT

		drdbsp32.ex_	..\system32\drdbsp32.exe	32-bit Dr. DeeBee spy used for debugging

		drdbsp32.dl_	..\system32\drdbsp32.dll	32-bit Dr. DeeBee spy used for debugging

		drvstp32.exe	not installed to hard drive	32-bit ODBC driver setup program

		dvrdel32.ex_	..\system32\dvrdel32.exe	Utility used to delete a 32-bit driver from the registry

		ds32gt.dl_	..\system32\ds32gt.dll	32-bit Driver Setup Generic Thunking DLL.

		mfc30.dl_	..\system32\mfc30.dll	Microsoft Foundation Class Library

		msvcrt20.dl_	..\system32\msvcrt20.dll	Microsoft Run-Time Library

		odbc.inf	not installed to hard drive	Installation control file

		odbc32.dl_	..\system32\odbc32.dll	32-bit ODBC Driver Manager

		odbc32gt.dl_	..\system32\odbc32gt.dll	32-bit ODBC Generic Thunking DLL

		odbcad32.ex_	..\system32\odbcad32.exe	ODBC Administrator Application

		odbccp32.cp_	..\system32\odbccp32.cpl	32-bit ODBC Installer Control Panel Tool

		odbccp32.dl_	..\system32\odbccp32.dll	32-bit ODBC Control Panel Installer DLL

		odbccr32.dl_	..\system32\odbccr32.dll	32-bit cursor library

		odbcinst.hl_	..\system32\odbcinst.hlp	Installation help file

		odbcln32.dl_	..\system32\odbcln32.dll	32-bit ODBCLink/SE Driver

		odbcls32.dll	..\system32\odbcls32.dll	32-bit ODBCLink/SE Driver Setup DLL

		r8ansi32.dl_	..\system32\r8ansi32.dll	32-bit character translation DLL for translation between the
				ANSI and roman-8 character set.

		r9ansi32.dl_	..\system32\r9ansi32.dll	32-bit character translation DLL for translation between the
				ANSI and roman-9 character set.

		setup.exe	not installed to hard drive	Microsoft ODBC Setup program drive

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

Image 87

Contents ODBCLink/SETM Limitations on Warranties and Liability ODBCLink/SE offers the following features Additional features of DataExpress for Client-Server areSales@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 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, enterTo determine whether or not the listener job is running To stop the listener# ps -ef grep odbclnse Create the DBEnvironment Gather InformationDownloading ODBCLink/SE to the Client PC Using Reflection softwareUsing Arpa Services FTP Using NS Services Dscopy on the HP3000\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 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 ImpromptuJoins Changing the display formatException 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 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 Odbc Call Tracing using ODBCLink.LOG Odbc Call Tracing using Dr. DeeBee SpyTools on the Client PC 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 MPE/iX Host HP-UX 9.x HostHP-UX 10.x and 11.x Host Page MBF-Console Introduction How MBF-Console WorksRunning MBF-Console Setup File Menu OptionsSet Refresh Interval in seconds Exit Configure DSNs... Console Data Sources ConfigurationConnect Menu Options PrintConnections Windows Listener WindowConnections 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