One2OneMileage supports direct connections to Microsoft Excel and Microsoft Access, but it can also connect to other databases using industry-standard ODBC connections. These are specified using a Data Source Name (DSN). One2OneMileage supports File DSNs, System DSNs, and User DSNs. System and User DSNs are defined in the registry. The underlying database should have ANSI compatibility switched on.
The DSN defines an ODBC connection to a database. File DSNs can be created using a text editor, but all DSNs are usually created using the ODBC Data Source Administrator in Windows. This is usually listed as Data Sources (ODBC), under the Administrative Tools of the Control Panel. Create a DSN that connects to the database of your choice. For example, you could use this option to connect to a remote Microsoft SQL Server database. The necessary authentication information (e.g. username and password) can be included in the DSN or specified in One2OneMileage at run time. The connection and authentication information must provide read/write access to both the table and the table's columns (including the location columns).
To use an ODBC connection, select any of the ODBC Connection options in the Data Source Type drop-down box on the Data Parameters dialog box. Enter the name of the required DSN in the Data Source text box. Although this can be typed in, it is recommended that you press the "..." button to the right of the Data Source text box. For File DSNs, this will display the standard Windows file selection dialog box letting you select the DSN (.dsn) file. For User and System DSNs, One2OneMileage will let you select the required DSN from a list of all of the available DSNs:
The Data Source area of the Data Parameters dialog box will display a couple of additional settings when either of the ODBC data types are selected:
First, the Set user to: check box lets you override the username/password that is defined in the DSN. Do this by setting the check box, and then pressing the Set User button to display the ODBC Login Details dialog box:
Using this option will override any existing login details defined in the DSN. Note that the password is never displayed. One2OneMileage does not save either the user name or password. You will have to re-enter these each time you restart One2OneMileage.
Secondly, the Details button will appear if the ODBC connection could not be opened. The other database types are relatively simple: the file exists and can be opened, or it cannot. There are dozens of reasons why an ODBC connection cannot be made. Press the Details button to find out why the connection could not be opened. The ODBC error code is displayed along with a text description of the error. The error code is a standard ODBC error code, but the text description will depend on the database server being used.