Setting Up the Example ODBC Data Source

These instructions help you set up the example ODBC data source that is used throughout this manual. This data source is based on a collection of CSV files installed in <document_root>\examples\data . Among other things, the example data contains statistics for a fictional baseball league over a five-year period.

Note: This database is installed automatically on Windows* systems, so you shouldn't need to follow these instructions.

To set up the example data source

These instructions assume you are using Windows NT/2000/XP. You must have Administrative privileges to perform this task.

1. Make sure that when you installed Corda® 7, you selected the Typical Install option.

   Examples are installed as part of a Typical Install, or by selecting Corda Server as part of a Custom Install. If you are not sure how Corda 7 was installed, look for <document_root>\examples. If the folder exists, the examples are installed correctly.

2. Open ODBC Data Sources Administrator.

   This can be done on Windows 2000 and Windows XP by selecting Control Panel > Administrative 7 > Data Sources.

   

3. Click the System DSN tab.

4. Click the Add button, located on the right side of the Data Sources Administrator.

   The Create a New Data Source dialog appears.

   

5. Select the Microsoft* Text Driver (*.csv,*.txt) option and click Finish .

   The ODBC Text Setup dialog appears.

   

6. In the Data Source Name box, enter CordaSamples.

   If you use a name other than CordaSamples, be sure to use make appropriate adjustments to the dsn source in the example code.

7. Uncheck the Use Current Directory box.

8. Click the Select Directory button.

   

9. In the Select Directory dialog that appears, locate <document_root>\examples\data .

10. Click OK to exit the Select Directory dialog.

11. Click OK to exit the ODBC Text Setup dialog.

    

12. Click OK to exit the ODBC Data Source Administrator.

    You can now access the Corda 7 example data source using ODBC.