PRODUCTS
PARALLEL CRYSTAL
   LATEST DEVELOPMENTS
   ARCHITECTURE
   DOCUMENTATION
   WEB PORTAL SERVERS
   ACTIVE X
SAFFRON PDF PROJECT
RESOURCES
   SAMPLE CODE
   FAQs

Allaire JRun and Parallel Crystal Sample Source Code

Running an SQL Script (DetailReadme)

Given a file of SQL commands (such as BikeData.sql, which may be viewed in any text editor), and an SQL connection to a database, it is possible to run those commands automatically. Simply type

at the SQL command prompt. This will create a table in the database named "BikeData" with 25 rows of bike-related merchandise, according to the commands in BikeData.sql. You can check this by typing

at the SQL command prompt. Setting up ODBC data sources

For Microsoft® Access

From the Control panel, open the ODBC Data Sources manager. Select the System DSN tab and click on the "Add" button. Select the "Microsoft Access Driver" and click finish.

A Microsoft Access Driver configuration window pops up. The Data Source Name should be set to "BikeData". In the Database area, click on the "Select" button and find the <path_to_JRun Sample> folder. Select the BikeData.mdb database from that folder and click OK. Click OK on the configuration window to finish.

For Oracle®

From the Control panel, open the ODBC Data Sources manager. Select the System DSN tab. Click on the "Add" button and select "Oracle ODBC Driver" (near the bottom of the list) and click finish.

An Oracle8 ODBC Driver configuration window pops up. The Data Source Name should be set to "BikeData", the Service Name should be the name of the Oracle database service to connect to followed by the database's internet domain name. It might look something like this: "Ora8DB.mobileapps.com"