Supported
Database Drivers
WBT Manager™ has been successfully tested with the following SQLServer
and Oracle database drivers.
SQLServer 2000:
SQLServer ODBC Driver (from MDAC)
v 2000.85.1117.00
(Note: no driver-specific
problems have been encountered with SQLServer since
before MDAC 2.5.)
Oracle:
Note: No version-specific problems
have been encountered with Oracle Server software or
Oracle Client Network software. However, Oracle ODBC
driver problems are quite common between releases. It
is recommended that you use the versions of the
Oracle ODBC driver and Oracle Provider for OleDB
listed below to avoid problems. These are the versions
that have been tested with WBT
Manager.
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
patch170_17 or patch180_5 will result in
unexpected permanent loss of course
structure information from the
database. Identify
and upgrade all 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
patch170_17 or patch180_5 will result in
unexpected permanent loss of course
structure information from the
database. Identify
and upgrade all 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. Use version
9.2.0.6.3.
|
| 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.
|
