An ODBC Data source name (DSN) is required for each Schema profile to facilitate connection to the database. You can create your DSN as either a 'User' or a 'System' DSN (however, if you want to run the EasyHL7 MySQL Schema Engine Service you will need to use a System DSN or you can set up the Service to run under the User context).
Follow these steps to create a DSN:
| 1. | Open the Control Panel |
| 2. | Select 'Administrative Tools' |
| 3. | Select Data Sources (ODBC) |
| 4. | ... alternatively, you could click on the button next to the DSN field in the Schema Creation window. |
| 5. | Choose the type of DSN you want to set up - in this example we are creating a System DSN so that we can run the Schema Engine Service. |
6. Select the MySQL driver to use
7. Complete the MySQL Connector page. In this example we haven't needed any other options than the ones you see in the first tab - your own requirements may differ (for example, you may have the MySQL Server supporting connections on a Port other than the default, in which case you would have to enter the port value in the 'Connect Options' tab.
8. Press 'Ok' to finish. Your new DSN should now be available to be used by the EasyHL7 MySQL Schema Engine.
