Navigation:  System Requirements > Server-side Requirements > Database (optional)

Prerequisite for a working Database connection is an installation of a JDBC driver on the application server respectively when using JDBC-ODBC-Bridges the configuration of a System DSN on the application server (Windows OS only).

 

Note: JDBC drivers are available for almost any database. Search the database provider websites for detailed information and JDBC driver download. The most important databases like ORACLE or Microsoft SQL Server provide JDBC driver setups for free. In case that no JDBC driver is available for a specific database, then it is possible to use the so called JDBC-ODBC bridge implemented by SUN in the SUN Java Virtual Machine (JVM). Using the JDBC-ODBC bridge it is possible to access the database from JAVA using an existing OBDC data source.

 

WebOffice 10.2 SP3 supports the following RDBMS:

 

 

SQL Server

 

To make a connection to a MS SQL Server database, be sure to have a MS SQL Server Native Client installed on the client machine. Follow Microsoft's instructions for the installation of the SQL Server Native Client on your client machine.

 

Note: Please find also more details in http://resources.arcgis.com/en/help/main/10.2/index.html#//002q00000038000000.

 

Oracle

 

When using Oracle as RDBMS, the installation of a correct Oracle client on your system is necessary:

 

Note: Please use in a single server scenario both, 32bit and 64bit Oracle client. The installation of the InstantClient is not enough.

 

The following software components have to be installed:

 

 

 

 

Access

 

On 64Bit Windows OS two different System DSN configuration applications are provided.

The configuration application linked in the windows start menu (respectively administrative tools) is the odbcad32.exe located in c:\windows\system32 folder. This is the application to set up 64Bit System DSN. If you use the Java and Tomcat 64Bit components, you have to define your System DSN here. Most ODBC drivers for 64Bit are currently not a part of a default OS installation. Search the database provider websites for detailed information. E.g. for a 64Bit ODBC driver for a Microsoft Access database see http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d. Note that installation may cause compatibility problems with installed 32Bit drivers. System DSN entries made in the 32Bit configuration application (see below) may be affected too. See MS knowledge base for details.

 

After configuration Apache Tomcat has to be restarted.