Please read the information below. -------------------------------------------------------------------------------- DataDirect ODBC Drivers 4.2 for iSeries Domino 6.0.3 and iSeries Domino 6.5.0 October 15, 2003 A) Requirements B) Installing the DataDirect ODBC Drivers C) Uninstalling the DataDirect ODBC Drivers D) Operational Considerations A) Requirements 1) To use the Lotus Connector for ODBC on iSeries, you must have: V5R2M0 installed 5722SS1 Option 33 OS/400 Portable Application Solutions Environment (Pase) installed. Pase is only supported on certain hardware models. For a list of supported hardware models, visit the following web page: http://www-919.ibm.com/servers/eserver/iseries/developer/factory/pase/ehardware.html. The following V5R2M0 PTF's installed: 5722SS1 SI07962 5722SS1 SI07963 5722999 MF30670 5722JV1, Option 5 (Java Developer Kit 1.3) installed 5722JV1 V5R2M0 Group PTF, SF99169, installed 5722JC1 (IBM Toolbox for Java) installed B) Installing the DataDirect ODBC Drivers 1) From the www.lotus.com page, download the version specific DataDirect ODBC file ("Lotus Branded DataDirect Connect for ODBC 4.2 iSeries 6.0.3 English" or "Lotus Branded DataDirect Connect for ODBC 4.2 iSeries 6.5 English") to a workstation of your choice, for example a Win2000 pc. 2) Create a save file on the iSeries. Depending on the Domino release: CRTSAVF QGPL/ODBCDD603 or CRTSAVF QGPL/ODBCDD650 3) FTP the pc file as binary to the iSeries save file. 4) Restore the installer from the iSeries save file to the /tmp directory using the following command: RST DEV('/QSYS.lib/QGPL.lib/ODBCDD603.file') OBJ(('/tmp/odbcdd603.jar')) or RST DEV('/QSYS.lib/QGPL.lib/ODBCDD650.file') OBJ(('/tmp/odbcdd650.jar')) 5) Run the Java command below to start the installer: RUNJVA CLASS(run) PARM('-console') CLASSPATH('/QIBM/ProdData/Java400/jt400ntv.jar:/tmp/ODBCDD603.jar') PROP((java.version 1.3)) or RUNJVA CLASS(run) PARM('-console') CLASSPATH('/QIBM/ProdData/Java400/jt400ntv.jar:/tmp/ODBCDD650.jar') PROP((java.version 1.3)) You will be prompted for input during the install. The following is a typical sequence of screens displayed during the install of the DataDirect ODBC Drivers for Domino 6.0.3: ----------------------------------------------------------------------------- -- Welcome to the InstallShield Wizard for DataDirect ODBC Drivers v4.2 for Domino 6.0.3 The InstallShield Wizard will install DataDirect ODBC Drivers v4.2 for Domino 6.0.3 on your computer. To continue, choose Next. DataDirect ODBC Drivers v4.2 for Domino 6.0.3 IBM Press 1 for Next panel, 3 to Cancel or 4 to Redisplay [1] ===> 1 ----------------------------------------------------------------------------- -- Software Licensing Agreement Press Enter to display the license agreement on your screen. Please read the agreement carefully before installing the Program. After reading the agreement, you will be given the opportunity to accept it or decline it. If you choose to decline the agreement, installation will not be completed and you will not be able to use the Program. ===> ("Pressed Enter") --------------------------------------------- "License Information" ("LI") is a document that provides information specific to a Program. The Program's LI is available at http://www.ibm.com/software/sla/ . The LI may also be found in a file in the Program's directory, by the use of a system command, or as a booklet which accompanies the Program. Press Enter to continue viewing the license agreement, or, Enter 1 to accept the agreement, 2 to decline it or 99 to go back to the previous screen. ===> 1 ------------------------------------------ Press 1 for Next panel, 2 for Previous panel, 3 to Cancel or 4 to Redisplay [1] ===> 1 ------------------------------------------------------------------------ -- DataDirect ODBC Drivers v4.2 for Domino 6.0.3 will be installed in the following location: /QIBM/ProdData/LOTUS/Domino603/EITODBC for a total size: 39.8MB Press 1 for Next panel, 2 for Previous panel, 3 to Cancel or 4 to Redisplay [1] ===> 1 ----------------------------------------------------------------------------- -- DataDirect ODBC Drivers v4.2 for Domino 6.0.3 will be installed in the following location: /QIBM/ProdData/LOTUS/Domino603/EITODBC for a total size: 39.8MB Press 1 for Next panel, 2 for Previous panel, 3 to Cancel or 4 to Redisplay [1] > 1 Installing DataDirect ODBC Drivers v4.2 for Domino 6.0.3 ... Please wait. ===> ------------------------------------------------------------------------------ Installing DataDirect ODBC Drivers v4.2 for Domino 6.0.3 ... Please wait. |-----------|-----------|-----------|------------| 0% 25% 50% 75% 100% |||||||||||||||||||||||||||||||||||||| -------------------------------------------------------------------------------- Creating uninstaller... ===> ----------------------------------------------------------------------------- -- The InstallShield Wizard has successfully installed DataDirect ODBC Drivers v4.2 for Domino 6.0.3 . Choose Finish to exit the wizard. Press 3 to Finish or 4 to Redisplay [3] ===> 3 ------------------------------------------------------------------------------- > 3 Java program completed ------------------------------------------------------------------------------- Once the "Java program completed" message is displayed, press enter to return to the Command Entry screen. ------------------------------------------------------------------------------- C) Uninstalling the DataDirect ODBC Drivers Uninstalling the DataDirect ODBC drivers v4.2, will require the following steps: 1) End all Domino servers for the particular version of the DataDirect ODBC drivers you intend to uninstall. For example, if you plan to uninstall the DataDirect ODBC drivers for Domino 6.0.3, then end all Domino 6.0.3 servers. 2) Run the following Java command to uninstall: RUNJVA CLASS(run) PARM('-console') CLASSPATH('/QIBM/ProdData/Java400/jt400ntv.jar:/QIBM/ProdData/LOTUS/DOMINO603/EITODBC/_uninst/uninstall.jar') PROP((java.version 1.3)) or RUNJVA CLASS(run) PARM('-console') CLASSPATH('/QIBM/ProdData/Java400/jt400ntv.jar:/QIBM/ProdData/LOTUS/DOMINO650/EITODBC/_uninst/uninstall.jar') PROP((java.version 1.3)) 3) You will be prompted for input during the uninstall. The following is a typical sequence of screens displayed during the uninstall: ------------------------------------------ Attaching Java program to /QIBM/ProdData/LOTUS/DOMINO603/EITODBC/_uninst/uninstall.JAR. --------------------------------------------------------------------------- -- Welcome to the InstallShield Wizard for DataDirect ODBC Drivers v4.2 for Domino 6.0.3 The InstallShield Wizard will uninstall DataDirect ODBC Drivers v4.2 for Domino 6.0.3 from your computer. To continue, choose Next. DataDirect ODBC Drivers v4.2 for Domino 6.0.3 IBM Press 1 for Next panel, 3 to Cancel or 4 to Redisplay [1] ===> 1 ----------------------------------------------------------------------------- -- DataDirect ODBC Drivers v4.2 for Domino 6.0.3 will be uninstalled from the following location: /QIBM/ProdData/LOTUS/Domino603/EITODBC Press 1 for Next panel, 2 for Previous panel, 3 to Cancel or 4 to Redisplay [1] ===> 1 --------------------------------- Uninstalling product... ----------------------------------------------------------------------------- -- The InstallShield Wizard has successfully uninstalled DataDirect ODBC Drivers v4.2 for Domino 6.0.3 . Choose Finish to exit the wizard. Press 3 to Finish or 4 to Redisplay [3] ===> 3 ------------------------------------------------------------------------------ Java program completed ------------------------------------------------------------------------------ Once the "Java program completed" message is displayed, press enter to return to the Command Entry screen. ------------------------------------------------------------------------------- D) Operational Considerations 1) In the odbc.ini, each data source definition includes a path to the shared library used for that Data Source type (data source type means which type of Database we are connecting to like Oracle or SQLServer). In the following example this path is marked with "<====": [DataSourceDef1] Driver=/QIBM/ProdData/LOTUS/DOMINO603/EITODBC/lib/LOmsss19.so <===== Description=DataDirect 4.20 SQL Server Wire Protocol Address=server1,1433 AnsiNPW=Yes Database=ROCH LogonID=uid Password=pwd QuotedId=No This path points to the shared library for the SQL Server driver. Each DataSource type has its own shared library. Notice that this path is different for each version of Domino. Compare the following data source definition for Domino 6.5.0 (this would be contained in /QIBM/UserData/LOTUS/DOMINO603/EITODBC/odbc.ini): [DataSourceDef1] Driver=/QIBM/ProdData/LOTUS/DOMINO650/EITODBC/lib/LOmsss19.so <===== Description=DataDirect 4.20 SQL Server Wire Protocol Address=server1,1433 AnsiNPW=Yes Database=ROCH LogonID=uid Password=pwd QuotedId=No 2) The DataDirect documentation is included with the drivers within the directory /QIBM/Proddata/LOTUS/DOMINOXXX/EITODBC/books/odbc, where xxx is the specific Domino version, such as 603 for Domino 6.0.3. 3) Back up the ODBC.INI prior to any re-install of the DataDirect ODBC drivers for a particular Domino version. The ODBC.INI is located in the directory: /QIBM/UserData/LOTUS/DOMINO603/EITODBC/odbc.ini or /QIBM/UserData/LOTUS/DOMINO650/EITODBC/odbc.ini For example,if the ODBC Data Direct drivers are installed, but then Domino for iSeries is deleted from the iSeries (DLTLICPGM), and Domino is reinstalled, you must reinstall the DataDirect ODBC drivers for that version of Domino again.