Cumulative patch 17 - Oracle 9 support and bug fixes.

Date: Feb 14, 2005

Version affected: v1.70.

NOTES:

This is a cumulative patch. It contains and will install all prior version 1.70 patches (except patch170_2 which corrects an installation program issue).

This patch will replace the web-server application's string table (strings.txt). Users of non-English versions of WBT Manager should contact their local reseller for an updated copy of this file.

Contents:

This upgrade patch includes minor upgrades and bug fixes to the WBT Manager Web Module.

Installation:

First unzip the patch files to a temporary directory.The patch includes 4 installation sets.

System Administrator Module

On each system where the System Administrator Module is installed:

Launch admin_module\seteup.exe

You will be prompted for the directory that the WBT Manager System Administrator Module was installed in. Verify that the path points to the correct directory and click "Next".

See here for a list of replaced files

Once installation is complete you can launch the System Administrator Module.

Web-Server Application

On the web-server where the WBT Manager Web-Server Application is installed:

Stop IIS web services (skipping this step may require a system reboot after installation).

Launch web_module\setup.exe

You will be prompted for the directory that the WBT Manager Web-Server Application was installed in. Verify that the path points to the correct directory and click "Next".

You will see a list of files that are being replaced that are not normally replaced during an upgrade. These files will be backed up before replacement. If you have modified any of these files you will need to re-do your modifications. Click "Next".

See here for a list of replaced files

Once installation completes you can re-start web services.

Batch Maintenance Module

On each system where the Batch Maintenance Module is installed:

Launch maint_module\seteup.exe

New versions of wbtm_mnt.exe and wbtm_mntctrl.exe will be installed.

See here for file details.

Student Import Tools

On each system where the Student Import Toolkit is installed:

Launch student_import_tools\seteup.exe

See here for a list of replaced files

Installation Set Utilities

Replace the copies of utilities\site_configuration\wbtmconfig.exe, utilities\conversion_tools\shared_status\sharestats.exe, and utilities\conversion_tools\status_rebuild\rebstat.exe in your copy of the WBT Manager 1.7 installation set with the versions in this patch. Or download a new copy of the installation set from http://www.ielearning.com/wbt/trial/application/wbtm170.zip.

Replaced files

Note: the following files may be found in the installation set directories beneath standard_files if there is a need to manually copy them or to examine them prior to installation.

System Administrator Module:

File Version Date
wbtman.exe 1.7.0.3 2/04/2005 12:22 PM
impexp.exe 1.7.0.2 2/04/2005 2:41 PM

Web-Server Application:

Destination File Version     Date
\winnt\system32\  wbtman4a.dll 1.7.0.7 2/07/2005 3:38 PM
\winnt\system32\  wbtman4b.dll 1.7.0.1 2/07/2005 3:39 PM
\winnt\system32\  wbtman4c.dll 1.7.0.2 2/07/2005 3:39 PM
\winnt\system32\  wbtman4d.dll 1.7.0.2 2/07/2005 3:40 PM
\winnt\system32\  wbtman4f.dll 1.7.0.5 2/07/2005 3:40 PM
\winnt\system32\  wbtman4g.dll 1.7.0.8 2/07/2005 3:41 PM
\winnt\system32\  wbtman4h.dll 1.7.0.2 2/07/2005 3:41 PM
\winnt\system32\  wbtman4m.dll 1.7.0.1 2/07/2005 3:42 PM
\winnt\system32\  wbtman4qp.dll 1.7.0.1 2/25/2004 12:44 PM
 
<web-dir> global.asa 7/8/2004 1:16 PM
reload.asp 7/9/2004 9:14 AM
page1.asp 7/9/2004 9:16 AM
fixiltflag.asp 11/20/2003 4:39 PM
strings.txt 2/04/2004 10:59 AM
 
<web-dir>\asp\ aicc_int_c1.asp 6/19/2003 8:26 AM
apiload.asp 7/15/2003 2:01 PM
cat1a.asp 12/29/2003 4:41 PM
cat1c.asp 6/21/2004 2:59 PM
cat3.asp 1/21/2004 3:01 PM
cat5.asp 2/03/2004 3:06 PM
crsmenu.asp 5/22/2003 3:18 PM
crsmenu2.asp 7/09/2004 9:21 AM
crsmenuxml.asp 1/8/2004 10:28 AM
enrollcertstud.asp 7/24/2003 1:34 PM
enrollcertstud1.inc 5/21/2003 12:23 PM
(existing file will not be overwritten)
fframe.asp 7/09/2004 9:22 AM
fixcert.asp 7/11/2003 8:54 AM
fixcert2.asp 5/14/2003 11:25 AM
fixcert3.asp 7/11/2003 10:30 AM
iltinstr3.asp 1/28/2004 12:16 PM
iltstud2.asp 12/30/2003 2:23 PM
isoffline.asp 7/09/2004 9:18 AM
kiosk.asp 10/04/2004 2:38 PM
kiosk2.asp 10/04/2004 2:32 PM
menu.asp 7/1/2003 7:29 AM
nav1.asp 7/09/2004 9:25 AM
(existing file will be backed up)
nav1_old.asp 7/09/2004 9:24 PM
(existing file will be backed up)
oflstart.asp 7/09/2004 9:19 AM
oflstart2.asp 7/09/2004 9:20 AM
r_adm7.asp 2/04/2004 11:03 AM
r_adm8.asp 2/03/2004 11:25 AM
r_adm9.asp 2/05/2004 10:41 AM
r_stu4.asp 12/11/2003 8:44 AM
r_stu5.asp 2/03/2004 11:20 AM
stringbuilder.inc 7/3/2003 12:42 PM
wbtconst.inc 1/30/2004 2:25 PM
 
<web-dir>\courses\ aicc_int_c1.html 6/19/2003 9:12 AM
 
<web-dir>\html\ enrollcertstud.html 5/14/2003 2:31 PM
(existing file will not be overwritten)
<web-dir>\html\help\ admhlp.asp 7/3/2003 1:21 PM
  admhlp.inc 7/7/2003 10:47 AM
  stuhlp.asp 7/3/2003 1:22 PM
  stuhlp.inc 7/3/2003 1:18 PM
<web-dir>\html\help\student\ wbtman170_content.js 7/16/2003 10:37 AM
<web-dir>\html\help\webadmin\ wbtman170_content.js 7/16/2003 10:40 AM
 
<web-dir>\html\xsl\ admin2.xsl 2/09/2004 2:39 PM
  assign2.xsl 1/28/2004 2:17 PM
  assign3.xsl 1/21/2004 2:45 PM
  austart_mode.xsl 5/21/2003 2:02 PM
  coursesel.xsl 1/16/2004 2:49 PM
  crsmenumakeentries.xsl 5/21/2003 1:50 PM
  dateformat.xsl 1/28/2004 2:21 PM
  depdic.xsl 7/7/2003 8:17 AM
  depdic2.xsl 7/7/2003 8:17 AM
  iltinstr3.xsl 2/06/2004 9:56 AM
  iltsel1.xsl 1/28/2004 9:53 AM
  iltsel2.xsl 1/16/2004 2:58 PM
  iltsl3.xsl 1/16/2004 3:00 PM
  iltstud2.xsl 12/30/2003 2:10 PM
  menu.xsl 3/10/2004 7:57 AM
  recalcrs.xsl 5/21/2003 2:09 PM
  report2_a.xsl 1/30/2004 11:15 AM
  report2_s.xsl 1/30/2004 11:15 AM
  resetcrs.xsl 5/21/2003 2:07 PM
 
<web-dir>\images\ admlog_d.gif 6/6/2003 10:41 AM
  ahelp_d.gif 6/6/2003 9:38 AM
  aloff_d.gif 6/6/2003 10:41 AM
  help_d.gif 6/6/2003 9:38 AM
  loff_d.gif 6/6/2003 10:41 AM
  stulog_d.gif 6/6/2003 10:41 AM
  checked.gif 2/13/2003 9:17 AM
  hline1.gif 12/09/2003 4:18 PM
  hline1end.gif 12/09/2003 4:17 PM
  smalledit.gif 1/19/2004 4:27 AM
  unchecked.gif 11/21/2003 9:08 AM
 
<web-dir>\jar\ austart.js 5/22/2003 10:23 AM
  bdetect.js 11/11/2003 8:29 AM
  crsmenuutils.js 5/22/2003 4:20 PM
  dhtml.js 5/20/2003 8:59 AM
  kiosk.jar 10/04/2004 2:36 PM
  kiosk2.jar 10/04/2004 2:42 PM
  lmsapi.cab 2/07/2005 12:54 PM
  lmsapi.jar 12/19/2003 4:29 PM
  popwindow.js 10/04/2004 2:43 AM
 
<web-dir>\msgtemplates\ enrollcertstudenrolled.asp 5/14/2003 3:21 PM
  enrollcertstudfailed.asp 5/14/2003 3:23 PM
  enrollcertstudnoprog.asp 5/14/2003 3:22 PM
  enrollcertstudnostud.asp 5/14/2003 3:22 PM
  enrollcertstudsuccess.asp 5/14/2003 3:23 PM
  enrollcertstudsuccessp.asp 7/7/2003 3:40 PM

 

Batch Maintenanace Module:

File Version Date
wbtm_mntctrl.exe 1.7.0.3 1/12/2005 3:05 PM
wbtm_mnt.exe 1.7.0.5 1/12/2005 11:30 AM

 

Student Import Tools:

File Version Date
 
simport.exe 1.7.0.5 8/10/2004 12:39 PM
wbtm_statusimport.exe 1.7.0.1 7/1/2003 9:47 AM
wbtmanager2.dll 1.7.0.3 2/07/2005 3:45 AM
simport.hlp 9/24/2003 10:11 AM
SourceCode Directory containing the VB6 project and source files to build simport.exe

Oracle configuration notes

Please read these notes carefully and pay attention to the red "cautionary" notes.

See the section below for the version of Oracle you are using.

Oracle 8.1.5:

Application

Driver & version

 

Net-8 8.1.5.0.0
(required by all applications) 

System Administrator Module

Oracle 8i ODBC Driver 8.1.5.5.0 

Web-Server Application
Student Import Tools
Site Configuration Utility

Microsoft ODBC for Oracle 2.575.1022.00 or later

Oracle 8.1.7:

Application

Driver & version

 

Net-8 8.1.7.0.0
(required by all applications) 

System Administrator Module

Oracle 8i ODBC Driver 8.1.7.8.10
WARNING: earlier versions of this driver will
result in errors during database access.

Web-Server Application
Student Import Tools
Site Configuration Utility

Microsoft ODBC for Oracle 2.575.1022.00 or later

Oracle 9.0.1:

Application

Driver & version

 

Oracle client 9.0.1.1.1
(required by all applications) 

System Administrator Module

Oracle 9 ODBC Driver 9.0.1.8.0
WARNING: Using the System Administrator application or Course Import application from versions prior to this patch (1.7.0.3) will result in unexpected loss of course structure information from the database. Identify and upgrade all WBT Manager version 1.7 copies of wbtman.exe and impexp.exe from administrator systems before attempting to use this driver.

Web-Server Application

Oracle OleDB provider 9.0.1.0.1

Configuration: Modify the "connectionstring" keywork in the "[database]" group in appsettings.ini to use OLEDB instead of an ODBC DSN. The following is an example (it should be on a single line in appsettings.ini):

connectionstring=Provider=OraOLEDB.Oracle;
    Data Source= <oracleservicename>;
   UserId=%%uid%%;Password=%%pwd%%

Student Import Tools
Site Configuration Utility

Oracle OleDB provider 9.0.1.0.1
Oracle 9 ODBC Driver 9.0.1.8.0

Note: Log onto the utilities using an Oracle ODBC DSN. Internally the utilities will detect this and reconnect using the OraOLEDB provider.

Oracle 9.2.0:

Application

Driver & version

 

Oracle client 9.2.0.1.0
(required by all applications) 

System Administrator Module

Oracle 9 ODBC Driver 9.2.0.6.3

WARNING: Using the System Administrator application or Course Import application from versions prior to this patch (1.7.0.3) will result in unexpected loss of course structure information from the database. Identify and upgrade all WBT Manager version 1.7 copies of wbtman.exe and impexp.exe from administrator systems before attempting to use this driver.

WARNING: Oracle ODBC Driver 9.2.0.6.5 does not work properly with WBT Manager.

Web-Server Application

Oracle OleDB provider 9.2.0.4.0

Configuration: Modify the "connectionstring" keywork in the "[database]" group in appsettings.ini to use OLEDB instead of an ODBC DSN. The following is an example (it should be on a single line in appsettings.ini):

connectionstring=Provider=OraOLEDB.Oracle;
    Data Source= <oracleservicename>;
   UserId=%%uid%%;Password=%%pwd%%

Student Import Tools
Site Configuration Utility

Oracle OleDB provider 9.2.0.4.0
Oracle 9 ODBC Driver 9.2.0.6.3

Note: Log onto the utilities using an Oracle ODBC DSN. Internally the utilities will detect this and reconnect using the OraOLEDB provider.

Oracle 10.0

Oracle 10 client software has not yet been tested with WBT Manager. It is recommended that you use one of the configurations listed above for earlier Oracle versions to access Oracle 10 databases.

Version 1.7 Patches