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.