Creating the data source name (DSN) entry
1. Click Start → Control Panel.
2. Double-click the ODBC icon.
3. Click the System DSN tab.
4. Click Add.
The Create New Datasource window appears.
5. Select the Microsoft Access Driver (.mdb) from the list and make note of the version (3.5 or 4.0).
6. Click Finish.
The ODBC Microsoft Access Setup window appears.
7. Type the data source name, this is usually swmData.
Refer to Determining the correct DSN below for more information.
8. Optional: Type a description.
9. Click Select to open the Select Database window. Navigate to the location of the Web Manager application folder and open the access folder.
10. Two database files appear in the left pane. Select swmData.mdb.
11. Click OK to close the Select Database window. Click OK to close the ODBC Microsoft Access Setup window. Click OK to close the ODBC Control Panel.
Your ODBC data source is now configured.
Determining the correct DSN
Data sources are configured through the ODBC control panel. The Web Manager is then configured to use a specified data source. This configuration is determined by the value in the setup.ini file in the main Web Manager application directory.
1. Open the setup.ini file in a text editor.
2. Locate the data source variable and make note of its value. For example: datasource=swmData.
3. If the data source value is not the same as the data source name configured in the ODBC control panel, return to the control panel and edit the data source name to match the value in setup.ini.
Related Links
Manual installation (Parent Topic)