The Racing System -- ODBC

ODBC

This page deals with the ODBC configuration which is required to run The Racing System. Under normal circumstances, these settings are established during the installation procedure and should not require any changes.

How ODBC is used

The Racing System uses ODBC to communicate with the database. We use the client-server database SQLAnywhere provided by Sybase. The database itself is named race.db and normally resides within the directory specified during installation. When the application is not running, this file is normally read-only.

ODBC Settings

To view the current ODBC configuration settings, use the following steps:

Start the Control Panel.

Run the ODBC applet as found in the Control Panel.

Select the Data Source named Race.

Click on Configure.

The following image depicts the default settings. See below for a table which contains the same information in text form.

Default Settings

The following table contains the default configuration settings necessary to run the application. We recommend that you do not change the values set by the installation procedure. Note that your values may be different especially if you have installed to a non-default directory.

The Racing System - ODBC Configuration
Data Source Name Race

DatabaseName Race

DatabaseFile C:\Program Files\DVL Software Limited\The Racing System\Race.db

Start c:\sqlany50\win32\rtdsk50.EXE -Q

Driver c:\sqlany50\win32\wod50t.dll

AutoStop yes

Restoring the ODBC Settings

If, for some reason, the ODBC entry for Race has been modified or deleted, and you wish to restore the original values, you can either do this manually or automatically. We recommend the automatic method.

Manual restore

To manually restore the ODBC entry, perform the following steps:

Start the Control Panel.

Run the ODBC applet as found in the Control Panel.

Select Add to create a new data source

Select the Sybase SQL Anywhere driver

Click on Finish

Fill in the fields as described above.

Automatic Restore

To automatically restore the ODBC entry, perform the following steps:

Download race_dsn.reg to anywhere on your machine.

Double click on the downloaded file and it will automatically load itself into the registry.

*The Racing System* - ODBC Configuration
Data Source Name	`Race`
DatabaseName	`Race`
DatabaseFile	`C:\Program Files\DVL Software Limited\The Racing System\Race.db`
Start	`c:\sqlany50\win32\rtdsk50.EXE -Q`
Driver	`c:\sqlany50\win32\wod50t.dll`
AutoStop	`yes`

[ About | Search | Feedback | Support ]