JDBC-ODBC Bridge
================

I would recommend the use of JDBC instead of JDBC-ODBC
since the support for JDBC-ODBC is discontinued.

However, for those who are unable to install SQL server
on their own computers, JDBC-ODBC can be used as below:

Load the JDBC Driver:
    Class.forname(sun.jdbc.odbc.JdbcOdbcDriver);

Connect to the Database:
    Connection conn = DriverManager.getConnection               (
     ("jdbc:odbc:SQLDatabase", "userid", "password");

Configuration at the JCCL System.
1. Go to Control Panel

2. Select BDE Administrator

3. Go to File ODBC Administrator

4. Click ADD

5. Find SQL Server in the list of drivers, should be
   the last one on the list

6. Click Ok and Click OK again(if needed)

7. Follow the on screen instructions.
   Make sure that the name of the database entered here is
   the same name that is used to create the connection in java.

8. Go to Client Network Utitlity in the Microsoft SQL 2000 folder
   (follow the steps outlined in SetupGuide.htm:
     "Client Network Utility - Connection Registration" section)

9. Create new user and set permission
   (follow the steps outlined in SetupGuide.htm:
     "Create a new user and set permissions" section)

--Prabu