SCRIBE Server uses JDBC drivers for connection with the database. JDBC drivers are .JAR files provided by the database vendors; some drivers are distributed with SCRIBE installation files (Oracle, Mimer, McKoi), while other drivers must be downloaded from the vendor's website:

Sybase - http://www.sybase.com/products/middleware/jconnectforjdbc

The folllowing file downloaded from this link must be copied into SCRIBE Server installation directory: jconn2.jar.


MS SQL Server 2000 - http://www.microsoft.com/sql/downloads/jdbcregister.asp

The folllowing files downloaded from this link must be copied into SCRIBE Server installation directory: mssqlserver.jar, msbase.jar, msutil.jar.

Note that in Windows environment, the process of downloading driver files from Miscrosoft's website places the files in C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib directory. In Linux environment, the user can download and unarchuve mssqlserver.tar file.


MySQL - http://dev.mysql.com/downloads/connector/j/3.0.html

The JDBC driver file downloaded from this link must be copied into SCRIBE Server installation directory and renamed to mysql-connector.jar.


Daffodil - http://www.daffodildb.com

There are two versions of Daffodil database - Professional and Standard (One$DB). Each version comes with its own JDBC driver file, named DaffodilDB_Client.jar. This file is located in the /lib subdirectory of Daffodil installation directory, and should be copied into SCRIBE Server installation directory.

Note: the Daffodil JDBC driver files are version-specific, the driver installed in SCRIBE must match the version of the database to which SCRIBE will have to connect.


StelsCSV - http://www.csv-jdbc.com

The StelsCSV JDBC driver works on a set of ASCII text files with a tabular (field-value) content, presenting each file as a table of a relational database. StelsCSV provides a basic set of standard SQL operations on the file data, including SELECT, INSERT, UPDATE, DELETE, table joins etc. An evaluation version of StelsCSV, limited to 20 SQL operations, is included in SCRIBE.